How do I set up a cell to display the last entry (of text) in a column,
regardless of what the text says...and have it update daily as more rows are
added to the column, and as the text entry may change...based on the formula?
Can anyone assist me with this?

I'm trying to create a conditional formula like:
=IF(OR(F2="Change",F2="New")*AND(G2="Auto CU")*AND(Q2=1),150,IF(Q2=2,200))
It works; however, if F2 is blank it still puts in the results either for
Q2=1 or Q2=2

Hi I am comparing two lists in excel. The first list contains part
numbers and it is my list. The next list contains part numbers and it
is the customer's list. I have compared both lists to determine what
the customer has and what I have. If the customer has it and I have it,

I have over 100 vinyl music records, EP's and LP's and I need to make a list
of them can anyone help?
Ian

I have a psreadsheet that has Part Numbers on columns A3:A2163 and the
quantities on column B3:B2163.
Some of the part numbers have repeats so I want to set it so that the
formula will add the repeating part number quantities.

I inherited an huge Excel spreadsheet and have come across the
strangest issue I've ever seen! I have a columns dedicated to "Date Rec'd"
and "Date Sent" and all cells are formatted to mm/dd/yy. However, when I type
in the date, a totally unrelated number appears (e.g., 4/4/2006 ...

My column has a formula in it that returns text, or " ", depending on the
data found.
I'm trying to do an "OFFSET" but keep getting an empty cell.  How do I
filter out the " " cells in the column?

here is something that should be much simpler to accomplish but somehow
is very difficult to figure out.
Basically, for simplicity's sake, let's say I have a simple spreadsheet
shown in TABLE 1 below which has Mon-Fri in one column and dollar of

I have a spreadsheet that I put Store names and addresses in the same cell
(say E5), I need a formula so that if E5 contains "Target" or "CVS" that in
cell F6 it will return a number. Should be easy can someone please show me
the formula?

Excel suggestion. It would be great if the 'Format' cells "Numbers Tab" would
allow you to format numbers with either English or metric systems weight,
length and distance measurements.
If anyone knows how I can add a 'g' for grams within a cell with out

I need to create a formula that says IF LEFT(A1,1)="7" AND LEFT(C1,1)="A" OR
LEFT(C1,1)="T" OR LEFT(C1,1)="G", THEN CONCATENATE(A1,B1,C1)
I don't know if I can use AND and OR in the same formula, or how to string
it all together. Help, please. Thank you.

text in cell A3 and text in B3.  When cell A3 matches a text in B3, I want to
link cell A3 to another sheet in workbook.  How?
Bob

I have a work sheet where I record daily costs for each item used.
I have a seperate summary sheet which I want to show that days cost for an
item and a cumulative total for each item.  I have tried VLookUp but cannot
seem to get it to roll on each day

I cannot figure out why I don't get a value with the following:
=IF(P79="Pass", SUM((N79),(L79*2),600),0)
I need to check that P79 = "Pass", then I need to add the values from N79,
L79*2 and 600 for a total score, or 0 if P79 does not equal Pass.

I am experimenting and trying to learn how the code works. I have the code
below. It gets hung on   S = "=" & Range(i).Value.
I am trying to have the program take the value in G6 and set that value to
S. Then loop back and take the next value  G7 and set that to S.