I lost the ability in the toolbars to see the full function band. I.e somewhere where I can type in the forumula. Which toolbar or setting allows this to...

I am trying to get a vllook up to be conditional if a certain criteria is met. I have tried =IF('Raw Data'!B$2=AB,(VLOOKUP($A4,'Raw...

Hi, Thanks in advance for your help. I am creating a calendar to see time availability from a huge table that list the room, the date, the day, and the time....

I have two cells containing the DCOUNT function. In the first cell, I have set the criteria to "Post-Phase 3". In the second cell, I have set the criteria...

How do I do a "show pages" on a pivot table in Excel 2007??? I did it in 2003, but can't figure out how to do it in 2007. Thanks!

I've copied data from a list and pasted it into a pre-existing list in an excel worksheet. I cannot get the two lists (the pasted one if just underneath the...

Hi, I am looking for a formula that can act as a filter. In sheet AA I have a table with headings products, date, diameter etc starting from col A. I would...

I need a formula that does the following: Calculates how old I am when a birth date is entered. The formula needs to use the calendar days not a fixed number...

If you have an ethnicity column I want to go to the next column and for all of a certain ethnicity I want to return either a 1 or a zero. Column A ...

I need to figure square footage of 2 dimensions, height, width, , leaving out a thrid number in the same cell, then multiply by a separate number. Any way to...

I have 13 copiers Each produces a csv with an account ID column, a mono page count column and a colour page count column, 6 times per year. The account ID...

First, apologies: My question must be answered in this and countless other forums, but I can scarcely even begin to 'formulate' my question in search...

trying to have my formula to either give me an account number or D9 is blank return a value of...

HI, I've added data (pasted it) into an spreadsheet, and now I'm unable to sort all of the data together. Can anyone tell me why? I had no problems doing...

I have an inventory list with inventory tag #'s associated with it. I would like Excel to indicate when a # in the sequence is missing.

I am trying to use =HEX2DEC(cell) but keep getting the "NAME" error. I believe it is because this is not listed in my available functions. How can I get...

I hit escape then I get a dialog box Continue End Debug End simply acts like Continue

how does one know if the data is hidden and how do i found out what data is hidden?

I need to create a macros will a pull down menue for a selection. Then questions will come up with room for answer. Can someone help, please