Hi guys this is my problem. I have serial numbers in my entire A column and dates in my entire B column. On a separate workskeet, I want to create a command...

hi again, in addition to my previous post, what formula can you suggest for me to be able to find matching dates and the dates of the week...

I am a service engineer, and i'm looking to use excel to manage my stock better I have tried a few things and it's all manually input/edited I would like to...

Hi, I'm looking for a function, similar to NETWORKDAYS, but that will allow me to add a number of working days to todays date to generate a deadline,...

Hi guys here is the issue. Under column A, which is titled serial number, I have listed the formula =IF(ISNUMBER(B28)=TRUE,A27+1,""). What this does is that...

Hi guys I recently decided to put in my students' attendance into a worksheet. A sample of one of the student's sheets can be seen at...

(Kinda long explanation here to make people understand what I want to know, just read the summary if you don't want to read everything here for topics I need...

Can we make a vlookup when lastname may have slightly differnt spelling in middle characters?

I have a Summary Workbook and it gets information from other workbooks Whenever I open it it will not update - it has an entry of 0 - I have to go through...

We want to make a vlookup on 2 columns ex;if a :b match with other woorksheet the contents of c:d shall be updated from second c:d explanation a: john b:Doe...

I need to compare two different spreadsheets. One spreadsheet has ticket numbers and amounts. The other spreadsheet has ticket number, amount, name, and...

How can I do that? Thanks

Hi, I can't figure out the way I should create this conditional formatting. It's probably very simple though. If a cell, let's say J5, is empty for three...

Let me start off by saying that I have been using Excel for several years, but self taught. I have come across a new challenge that I just can't figure out....

I am trying to do a simple IF function but don't know how to indicate if a cell is empty or blank then I want a certain text value returned. What I am trying...

Use the example below, "," is the delimiter between cells. item1, content1, code1, 111 item2, content2, code2, 23 item3, content3, code3, 11 item1, content1,...

Is it possible to have a cell background color change when a particular condition is met? In this case, specifically a DATE. When an item is entered in a...

Hi all, I have a need to select and store unique cell contents in a large number of rows. I guess I would like a formula that looks something like...

Version - Microsoft office 2003 - Just a regular spreadsheet with data. I have clicked into one of the cells & im trying to add a pivot table however when I...