Hi
Im a VBA novice so please take it easy on me.  I know of it and think I can
get it to work but it isnt taken for granted that I can.   I have lots of
worksheets on one spreadsheet which hold financial data like this:

hi
I wnt to do numbering in excel sheet . There should be a prefix like:
ANA etc. for each row.

Hi! I ´want to use the worksheet function LARGE for three different cells.
however the cells are not placed next to each other (and i cannot change
that) and that gives me alot of trouble. is there any way to solve that?
thanks!

I am setting up a physician call schedule.10 people  7days/week. Can I have
excel count how many times each doc has taken call on each day .

I have a worksheet where I need to select a value based on which cell in a
non-contiguous range has the MAXimum value.
To be more specific,
There are 4 cells in column E (26, 35, 43, 47) each with values < 200.

How to sort a column of text alphabetically so that the contents of the
relative rows automatically sort with the column?
The A-Z sort function seems only to work with the individual column.
Any help, gratefully received.

I have a worksheet that contains a formula that takes the form
=IF(ISNA(My_Expression),0,My_Expression)
The precise formula is
=IF(ISNA(MATCH(A18,Rates!FromDate)),0,MATCH(A18,Rates!FromDate))

when i send out a spreadsheet and have custmer addrress iwant delite the
adress partly to protect the custmer

When using the Auto Filter on my spreadsheet, quite often I find when I try
to filter it seems 'stuck'. The only way I can deal with it is to remove the
auto filter function, highlight my spreadsheet and "unhide" (as anything
filtered out stays hidden). Then I can reset up the ...

I've got a handful of issues to work through with a particular project
I'm working on but let's start with the first: reordering part of a
list with VBA.
I have a list on a hidden tab (let's be adventurous and call it the

I have a third shift and using excel to calculate time 10:30 to 7am all the
other shifts calculate fine useing =sum((A6-A5)*24(A4-A3)*24), But useing
this formula the third shift comes out in negative numbers any suggestions.

To begin with, thanks to all those who answer the million questions posted
here. Amazing the quantity of different problems people come up with and
astonishing the amount of time several devote to solving them. My hat off to
you.

I have already used the dropdown suggestion in contexis's website and it does
work.  The question I have is in regards to the fact that I am looking to
convert my spreadsheet to HTML and no one can do it with OFFSET function
being in the Data > Validation section.  So, is there ...

I've seen other posts for this same type of question, find the smallest
number not equal to zero, but the following still returns a zero.  Any
suggestions?
=MIN(IF(Q33<>0,Q33),IF(BC33<>0,BC33),IF(BM33<>0,BM33),IF(CA33<>0,CA33),IF(CO33<>0,CO33),IF(DC33<>0,DC33),IF(DP33<>0,DP33) ...

First off, Hello!
I am new to the group so please bear with my stupidity...
I have an Excel SS like this:
Brand    Store Number Shipped/Receive Date    Item 1    Item 2     Item 3