I've been using vlookups for a couple of years now and my colleague and I
have noticed that when we use them in large speadsheets (50k lines ) the
- Feb 22 Thu 2007 20:35
Vlookup gives wrong answers when used in large data. Pls advise?
- Feb 22 Thu 2007 20:35
multiple rows with some dups where I need result on one line
I have the following cells A1:A4 and B1:B4 where I need the duplicates in
column B one time and the corresponding results from column A combined in one
- Feb 22 Thu 2007 20:35
why after mailmerged the data can not be read?
i facing a problem which is quot;after the mailmerged, the data is not appearquot;
but the data is ready in the Microsoft Excel.
- Feb 22 Thu 2007 20:35
If Formula Question
Trying to put this into Excel.
- Feb 22 Thu 2007 20:35
if statements
- Feb 22 Thu 2007 20:35
spreadsheet for expenses and payments?
i need a spreadsheet that will help me track children's expenses, child
support payments or the lack of them, insurance reimbursements from their
- Feb 22 Thu 2007 20:35
shortcut to insert cells
Is there a keyboard shortcut to insert rows?
- Feb 22 Thu 2007 20:35
VBA help (and other) please
Me again,
A few items:
- Feb 22 Thu 2007 20:35
If 2 cols meet a criteria then sum the 3rd column
I am trying to SUM col3 if 2 cols meet a criteria eg If COL 1 = 2222 amp; col 2
= ABCDE then sum col3. Is this possible
- Feb 22 Thu 2007 20:35
Can you write a formul that will put multipal answers in multipal.
I am trying to write a formuls that has a constant value (we wil call it cell
C14) that looks up that number in a different worksheet and imputs the