Hi all, using excel 2007 I would like a formula to test a column to find out whether the cells in the column are either a constant, a formula, or a name...

I have a simple chart where I want to calculate my costs as a percentage of revenue. So, I basically only want to see three or four columns: Clients,...

I am making a spreadsheet calculator Using a drop down menu there are 10 choices for 'Characters' Depending on the 'Character' selected, there are 30 different...

First, thank you for helping. I hope this makes sense. I'm trying to come up with a formula that will display the AVERAGE amount of days a PO is open. The...

Hi all, I want cell b1 to display the current date and time based on cell a1's entry. I want the date to remain constant and not update unless a1 has been...

Help!!!! this what I have. I have a work book with several tabls each tab represents a week day (example: Monday, Tuesday, and so on) Each day is a work...

For Example: If I have a column with 8 items but two are duplicates. I want the formula to return a value of only the unique items...

I like to enter a multiple IF funcution formula that looks like this: =if(a105,x1+1,if(a10510,x1+2,if(a101020,x1+3))) Always getting an FALSE message what...

Hello from Steved Please my objective is as set out below 547 to become 5.47 600 to become 6.00 912 to become 9.12 and so on how do I acheive this I...

I have thouands of rows of data with part numbers for items. In the columns for that part number there are multiple rows of data. What configuration of a...

I am trying to create a formula that combines the COUNTBLANK function with a COUNTIF (or SUMIF)-type function using the following Excel data: A ...

Hello, I am new to Excel. I need help assigning numbers to a group of names. I have 2500 names to assign...don't really want to do it manually! Example # ...

I have a start time(22:13) in b3 and an end time(3:06) in c3. All times are entered in 24:00 format. In column F, I have one hour increment time values...

This is the formula IF C2:C60 = C76 AND IF D2:D60 = L75 SUM(A2:A60). How would this be entered

I have data that includes amounts and dates. When I put these items in a pivot table, I want the amounts subtotaled but not the dates. My data...

I have the following 2 macros as buttons on a custom toobar to Shade or Unshade cells. Sub Shade_Cell() ' ' Shade_Cell Macro ' ActiveSheet.unprotect...

I have a conditional format that "asks" if the cell is a formula, use Black font. If its a manual input number, use Blue font. (With the help of this...

I've added a spinner to my NPV analysis with regards to the discount rate. What I'd like to do is use increments of .10 or .25 as opposed to just whole...

Mike / Gord Just had another thought regarding capitalising. And yep! It would be just as easy to use the Caps Lock, but most of the "Gate-house" staff...

Is there a shortcut to move back and forth between sheets in the same workbook? Similar to how you can move between screens by pressing ALT+TAB