I am trying to figure this out... I want to do something like =OR(K2:K(L2) =30) where L2 is a variable number, so it would end up being L2 = 4 (but it is...

I export data from another program into Excel. This data contains dates which are formatted like this: yyyymmdd000000. When the data is imported into...

I'm working with a spreadsheet that has automatic calculation disabled because a large number of UDF database lookups refer to one cell and recalculating the...

I have a huge table with account numbers and I need to find out all the ones that are repeated in one column so that I can delete them and just keep one...

I have the following Vlookup formula =ROUND(IFERROR(VLOOKUP($D196,'000-00'!$A$13:$AL$200,F$1,FALSE),0),0) I want to have '000-00' change based on combining...

Hello Group, I have this code that i found in searching the forums, but i have a question. I need to allow them to access two unlocked cells and a...

I am trying to locate a matching value and return its columnheading. Ex A5=vlaue to find in row5 to return column heading a4:z4 hlookup(a5,b5:z5,(return...

Hi, I have an about 50 cost center reports where the formatting are all the same, numer of rows, columns etc. What I would like to do is to have a "master"...

Since the upgrade to Office07 (yuck), pushing the AutoSum button, or Alt+= gives me a SUBTOTAL() function instead of SUM. Of course I can manually type the...

Ok, have used this formula to look at two criteria and gives me a sum. However, if there are more that two criteria in column B, which includes for examples...

I am trying to balance a checking account in excel. I want to keep three cells linked to one another, for example check #, Date, and amount from a registery...

I am trying to figure which formula to use for the following type of scenario. I've simplified it to make it easier to understand the concept. Column A has a...

I've to cells titles width and height I need cells beneath them to create borders equal to the sizes ex: i need a 24 x 36 to have borders with a vertical...

Please I have this A1 box A2 book A28 Jug A200 box = b200* (Find Box in A1:A150) i.e b10*A1 A201 Jug = b201* (Find Jug in A1:A150) i.e b10*A28

I'm trying to do a count if with 2 criteria - the difficulty I'm having is the 2nd criteria involves a calculation - please see example below; Table 1 Col A ...

spreadsheet (a) that was open before new data saved as another spreadsheet (b) no longer updates automatically without opening & closing (a) or using the...

I´m working with a Excelbook where I use diferent sheets in the same book for collecting information depending on the value of a cell in an annother sheet....

I have a spreadsheet where I want to sum all data where Feb appears in Column A For example: in the cell that I put the formula, I should get 18. Any...

I am looking for a way to round up a number if the decimal number is greater than .25. I looked at the ROUND and CEILING functions but can't seem to put a IF...

I have a spreadsheet with pupils marks and grades for many exams. I need to find their best grade A*- U over 8 exams. The grade records are in in every 4th...