I will thank you in advance for your assistance :) I have created bingo cards for a fund raiser. I had the cards created using random numbers 1 through 75 (15...

when I put a dash (0005 - 001) excel changes the dash to a zero and it is driving me freakin crazy. It just started doing this.

Hi There, I would like to set up a formula that recognizes the text (i.e. render or "R") I have noted in a cell and assign a color to it...whichever color I...

I am trying to get Conditional formatting to achieve a result to no avail. Here is what I'd like it to do: Column A - if cell, in Row is 0 then shade active...

I'm updating data on a workbook I didn't create. Worksheet A begins on line 1, worksheet B and C begin on line 3. Lines 1 and 2 are missing from...

I want to shade a cell a specific color dependent upon an IF statement. ex. IF(ab, color the cell red, color the cell green) What (if any) is the call to...

Good afternoon, I downloaded a MS template for project management and it is laid out like this: Cell D Cell E Numbered Days Across...

For example: 156 SQFT x $10.00. Where 156 SQFT is all in a single cell. Is there a way to ignore the alpha characters and only look at the...

Well I think it shouldn't be a big prob but the thing is that i dont know the solution... below is the example of...

Hi Everybody, Normally when we specify range in excel we specify as $A$1:$A$1000, But I for my specific problem I need to specify range using a vlue of a...

My data set varies in length and would like my SUM IF formula to always pick that out. I’d like to eliminate going into the formula and changing the...

Hello, I have some functions in my spreadsheet that returns "#REF!". That is OK, however I'm wondering if there is a way to format the spreadsheet to...

Hello, I need to strip text in a cell and have attempted a number of solutions without total sucess. The cell data consists of dimensional information: 73 mm...

I have a seating chart with a cell I don't see a formula for. I can enter the seat number (ex. 12345) into the cell (B1) and it will move to and highlight the...

Greetings I'm trying to find a compact formula. On sheet1 cell A1, I want to test that cells A1 on sheets 2 through sheet 102 contain text: "goat". Has anyone...

I am a teacher and use a spreadsheet to keep a record of when students have completed an assignment. I need to produce a monthly report detailing how many...

Hi everyone I need help about creating formula that contains date not an amount. I tried everything but did not figure out how For example; Shipping lead time...

Greetings. I am compiling an archive of the recorded lectures at a university. I am trying to have Excel automatically add a specifically formatted reference...

Hello all, I can get the last value in column F by using LOOKUP(9.99999999999999E+307,F:F) on the same sheet but have no success in geting this value from...

I need to write an excel formula that calculates hourly wages up to 30 hours and then time and a half after 30 hours in one formula.