I have items that have been assigned an ID number. How can I extract a list of unassigned numbers? I.E. I have number range starting with 7200000-7232000....

Hi Is it possible to group data together so that it stays together when I sort it alphabetically? I'd like to make a list for example, Police, Fire...

HOW CAN I SORT BY ALPHABETICALLY FROM A TO Z BY LAST NAMES PLEASE

In MSWord, formatting can easily be set so that selected text is always in capitals by FormatFontsAll Caps. Can text in Excel be similarly formatted?

How can I average certain number of lowest values in a column?

I need to fill in the blank cells with the information from the cell above until the next cell is not null. For example: Column A Bill blank blank Bob I need...

is it possible to add 6 months to a given date? i.e. if in cell A1 the date is 04/05/03, then cell B1 should return the date plus 6 months ie 04/12/03. the...

Hello all, I have the following code: Sub DelOver16() If ActiveCell.Value = 16 Then ActiveCell.EntireRow.Delete End Sub

I am trying to do my homework again. I have done everything I can to get this to work and I keep getting error messages. I am trying to get the letter grade...

When I call the function Dir("Q:\") and Q:\ is a network mapped drive does it fail (return "") if it does not receive a reply within a certain time-limit? The...

I want to average a group of percentages but want to exlude cells which have the value 0 (some of the cells have 0 for the numerator and denominator). What...

how do i combine multiple rows that contain text

Not a nice thing to say to a coworker, but was he right. I had a discussion with a male collegue about the difference between and empty cell and a cell with a...

I'm not familiar with excel, but i have a list of 2400 items that i need to narrow down to items less than a certain amount. someone help me?

I need help Creating A document in Excel, with rows and columns

Greetings all hopefully this is a simple question. In an IF function I would like to have the value that is returned when True to be one color (green) and the...

I have 100+ spreadsheets which i have to edit into a certain format. The spreadsheets currently have 100 columns (from 1-100). From there i have to reduce the...

I have classwork to perfoerm on EXCEL, but I am unable to use the Chart Wizard because it is grayed out, and unavailable. I have made certain that I have...

Hi, is this the correct formula to calculate mortgage interest on an interest only mortgage? =SUM((B3*B4)/12)*-1 where B3 is the mortgage and B4 is the...

I want to make a chart/graph that will have 3 columns where I can enter my bills and have them automatically calculated. !st column the name of company, Second...