Could someone please tell me why I get the #name? error when I open the spreadsheet? I run macros for comments and I have the workbook shared and protected....

Want to create formulas outside of a pivot table yet still reference the data within the pivot table. I can manually write the cell name such as...

We want to use Excel to track printing in our office. I am able to get all the info needed into a spreadsheet, but I have one 1 remaining glitch when I need...

When put in the conditional formatting dialogue box, this formula =VLOOKUP(a1,$b1:$c50,2,FALSE)=1 for box 1 w/color code red, (a1,$b1:$c50,2,FALSE)=2 for box...

89 87 67 67 65 56 5 10 4 4 8 3 This should be...

I am trying to create a conditional formula that will tag cells with data points =0 as "1", if not =0, then a tag of "0". Excel is identifying blank cells...

I have located data in a table with a VLOOKUP. How can I get the actual information located in the sought cell plugged into the new location instead of the...

I'm trying to create 25 bingo cards with 27 possible values, distributed randomly on each card. I'm running into the values being repeated on the same card....

How do I merge text and data fields without loosing zeroes to the right of the decimal point? .00 I'm using the following 2 formulas to merge more that one...

In Case You Missed My First Post !!! I'm producing a template for a football pool I am in. It's called a "Margin Of Victory" pool. Just like...

Suppose I have a column of numbers, say in A1 through A600... The =SUM(A1:A600) works perfectly for the sum. Now, for successive formulas, I wish to use the...

I need to input today's date in my worksheet. But, I want that date to stay THAT date when I open it up a month from now...I don't want it to change to...

I'm setting up a "biggest loser" spreadsheet for a group. In one column, I'm putting in the weight at weigh-in each week. In another column, I want to keep...

A B Row 1 Mark Bressler Row 2 Joe Smith My data looks like the stuff above and I want to convert it into...

giving one column in time one column to out time conditions are Rs 5 for 15 minutes Rs10 for 30 minutes Rs 15 for 60 minutes Rs 75 for 20 minutes Rs 90for...

Hi. I seem to have a problem. I have a very large Excel file with two sheets (each shed has aprox 3,000 rows) whereby the data entered is on the "Audit" sheet...

Hello Experts: I have several names posted several times in Column A and which will change from day to day. How can I count all occurences of each name in...

I'm trying to round a 4 digit number to it's nearest 10. Example 1234 to 1230 or 1238 to 1240. How should I do it?

How do i, after pressing a button find a row in sheet 1 which has "Max" in colum F Ser Ser No Date Insp Rate Date Next Insp Test Type ...

can anyone tell me how to sort data to show repetitve data and highlight it in the array?