I currently have a function I need to append to for a whole column:
=VLOOKUP(I1,'Male Tables'!AJ4:AT140,AS1)
=VLOOKUP(I2,'Male Tables'!AJ4:AT140,AS2)
=VLOOKUP(I3,'Male Tables'!AJ4:AT140,AS3)

Hey Everyone, I normally can find an answer but so far I dont see this answer.
How can I hide an answer in Excel.
Im doing a banking spreadsheet and I want to hide the total for the blank
cells.

I am multiple worksheets and am running into a problem.  The formula I have
utilizes constants (i.e. $Y$4) to demarcate the last cell in a column.  For
instance, if the column expanded from Y1-Y100 I would use $Y$100 in my
formula for each cell in another column (i.e. column Z).  ...

i need a formula to count the amount of cells with the same number in the two
cells. at the moment im using =countif(range,"="&range) but when i use this
it counts the blank squares which i dont want it to. i cant enter text into
the boxes as i have other formulas using them ...

Hi someone,
I'm trying to find and return specific text (the 14th and 15th character)
from a cell, but only if its one of 6 different values (ex. "ip" or "iv")
can someone provide a formula that could return only these 2 values, and i

I work in a hospital and am trying to automate the production of waiting
lists from an Access table, imported into a separate Excel workbook for each
month.  I'm stuck on how to name each workbook sequentially within the macro.
The convention will be:

i build a table that seems to work properly.
On the vertical axis i have 3 values and 5 on the horizontal.
No problems at all.
BUT

Can anyone suggest why autofilter fails after around 20 rows on my spreadsheet? I have a column of "Y"s & "N"s which I want to auto filter but after about 20 rows the auto filter fails. I have ensured there are no blanks in the column which is usually the cause but I am now out ...

If I have a list of values (all different numbers) all in a column, and I
want to select values within that column that equal a specific total, is
there a function in excel that will help me?

I'm trying to create a tool that can help me with Sudoku (I'm gettin
bored of charting the possible values of a given cell).
To do this, I must find out whether a given value (for example 3
exists in a specified range.  I can't find a function that does thi

I am trying to make a monthly time sheet.
This is the layout
     A                  B                 C            D              E    
        F             G      

When I copy a workbook from one computer to another, the copied workbook
links still refer to the original. How do I set up or copy the workbook while
keeping the calculations within the same workbook?

Hello Friends, I have a simple database of 324 names and their
characteristics are detailed on each column (for example: address, male,
female, English, Spanish, etc...). I use this database for a Word mail merge.
What I am trying to do is that each time I add a name to the ...

I have a data table with a column of data called "durations" with value
from 1 to 14, but some are missing (there's no 6 or 13).  On my pivot
table I want the column headings to be the numbers 1 to 14 without the
missing figures.  I know I could add these as dummies to the data

I need your help. I have a worksheet with many rows and 6 columns. Every
column has one number. I need to delete every row that has 3 or more numbers
followed.
E.g.