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

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...

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....

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...

How can I do that? Thanks

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

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 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...

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

(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...

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...

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, 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,...

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 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...

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...

Some documents I receive in exel format have sections that I need to respond to then return to sender. Often the spell check option is not available in the...

We have a workbook which has name in column b we have another sheet with same names but column 1 has id# we would like to have those codes whatever we tried...

Hi everibody In column 1 are cells with different values (some cells have 10, other have 100 other have 500 etc); How can excel say "there are X cells with...