complicated excel formula

Hi, Please help! I have a file with multiple sheets. The same products, but from different countries so they have 70% the same names. They all have different prices but in the same currency. I need to be able to have the first row with my name of the product (the one that I set), my price in...

Hi all, Got a sticky situation that is stressing me out, so need expert help!! I need to change the cell contents in reverse order - kind of sorting the cell Z-A but by line. I want to reverse the cell layout so that the latest comment is at the top. ie Comment 5 followed by 4,3,2,1 (the...

i need help with some formulas for this sheet i need to create basically what i want the sheet to do is to locate the names in column 1 who have value greater than x in column 2 and then reflect it into a new tablet now i'm very open minded like if there will have to be several sheets or if...

I have a table that gives me a list of reasons why a lab cannot be reported on yet, and many times there are multiple reasons (we have a total of 19). The customer wants to know why we can't send them results yet so we send them a report with a reason, however we want to give them all of the...

​ <tbody> A B C D E F G H I 1 <tbody> 27-Feb14 </tbody> <tbody> 28-Feb14 </tbody> <tbody> 1-Mar-14 </tbody> <tbody> 2-Mar-14 </tbody> February March April 2 3 4 X 5 </tbody> <tbody> if range of cells A4:AD, contains...

Hello! I have a pretty complicated spreadsheet to work on and I need some help. The spreadsheet has lots of merged cells which I managed to resolved. 1. I tried to sum the total time but it just return as 0:00:00 - I have formatted the cells as [h]:mm:ss. Any ideas what is causing the return...

I have inherited an Excel Spreadsheet (Excel 2002) at work which contains the following formula (it contains 381 characters). The calculations are mostly to do with money. Some of the answers I get are correct. Some are a penny out and others are several pence out. Does anyone know if this...