I have the data in excel of medical but facing prolblem to sort or correct
data shape is like this
OPD No,   Employee No.  Name of Medicine.   Prescribed by.   quantity.  price
1                  0001                                      Dr ABC          

is there any exel fuction to counting how many distinct data like distinct
funtion on sql programming
example
1 ab

work with Excel 2000 - direct mail databases - I would like to be able to
start on any row I choose and have a macro to choose the very next 2500 rows.
Is this possible?

I need to format various columns of data so that the highest value in the
column shows as bold (ie; cells A1:A300 - A57 is bold as it has the highest
value).
I am trying to do this in conditional formatting by selecting the range (ie;

Hi! I have a program that exports data to Excel. The problem is that the
dates are in a format that is not recoginzed by Excel as dates. They look
like: 1997-maj-08, 1997-sep-24, 2005-jan-10 and so on. Is there any way to
covert these dates into normal Excel dates? If you know of ...

In Excel 2007;  How do I turn on "View Side by Side" it show in greyscale so
obviously is off and I cant see how to turn it on

I have an excel worksheet:
ID                       Date                 Company                  
Transaction_Code
001                    10092007          LG Electonic                        

I am using the following formula: =IF(M5="x",W49*140%,IF(Q5="x",W49*140%,""))
but I need to change it to solve the following problem,
1. How can I use 4 cells J5, G5, M5, Q5, I need to insert a caracter into
any of this cells (at this moment I am using "x") But I really want to be ...

I have formatted a number as 0.00" C/Mtres" and it returns the result
of ####  because the column is too narrow.
If I don't want to make the column wider or reduce the size of the
font how do I fix this?

Is there any function to change the cell color ?
for example:
if Cell A1 is "001" it should be "Green"
if Cell A1 is "002", it should be "Pink"

I would like to round time to the nearest minute in Excel. For example have
a time that is 7:03:01 and 7:03:59 and they both appear as 7:03 with the
format h:mm when I would prefer they appear as 7:03 and 7:04. Can anyone
please tell me how I can do this.

I have two columns of numerical data in range a1:b40. The cells hold values
from 1 to 9.
I want to count the number of times 'column a' data is less than or equal to
'column b' data.

I need a formula that evaluates a cell and if that cell is 15000 or below the
spreadsheet multiples another cell by a certain percent, putting the result
in the current cell, if the first cell is between 15001 and 25000 it
multiplies by another percent.  This goes on for four ...

If I take a Fourier Transform of Acceleration data in Excel, what units will
the output data be in?

Hi have a spreadsheet which has lines for every minute of the day
20/8/07 1900
20/8/07 1901 etc etc for a number of weeks.
How do I easily find the average of each 15 minute period without having to