Hello all I have a workbook with multiple sheets. Each sheet is identically laid out (the only difference is the sheet name - cart1, cart2, etc). Each...

Sub Inspectthis() Dim F As String Dim I As Integer Dim PrevRow As Long Dim R As Long Dim Rng As Range Dim RngEnd As Range Dim SumArray As Variant Dim Wks As...

I need Help with a formular !!!!! C1 6.5 D1 7.5 E1 Actual F1 I need result if the Actual = 0.00 - 3.24 I need result verry low if the Actual = 3.25 - 6.49...

I dont even know where to begin with this one... If Row A has the digits 23, 83, 849, 759 and Row AL has the value of RESEARCH then provide me a list of all...

I have a huge list of names in this format: Last name First name DOB in three rows, I need to get it down to two like this: Last Name, First Name ...

I have two questions about Pivot Tables. To generate these pivot tables, I am querying an Informix Database through an ODBC link. I'm using Excel 2003 and...

I need a formula in cell C1 that when A1A5 it appears the text in cell A2 and when A1A5 it appears the text in cell A4. Thanks in advance

I have rounded some numbers to the thousands digits. I need help finding a formula that rounds the displayed (rounded thousands) digits. Everything I try...

Hi I have a formula which needs to work out which cell it is located in, then calculate the reference or another cell 1 column to the right and 4 rows above...

I've four columns of data over three hundred rows : Gender - M or F Grade - 1 to 15 Company - Five text names Salary - Integer figure I want to be able to...

I have a macro to be released to a number of positions held not by the same person. This is to be run with a New Worksheet with data created from SAP, so...

Hi I am using EXCEL 2007 and one of my file is shared work sheet. when i try to open the file i am getting a error "unexpected file lock by "user". Do any...

Dear expert, I have a a list of "if" criteria in row 1. If it is matched, it would show up the names in row 2. Then in A3 I use =A2&" "&B2&" "&C2&" "&D2&"...

Hi, after reading countless forum discussions, i am still very confused for something that should be fairly simple! i have a workbook file with several work...

Hi - I have a simple spreadseet with one formula, 30 rows of data. However each time that I change the cell and select a different cell, excels is delayed. ...

Hi Help needed A1 3.5 B1 4.5 resultin C1 if less than 3.5 i need "low" if between 3.6 and 4.5 i need "medium" if higher than 4.6 i need...

Not sure if the subject makes sense I have 2 dates Rate = 8% Start = 12/28/2009 End = 2/18/2010 This is 7 weeks 3 days Daily interest = .08/365 = 0.02192%

OK

is vlookup limited in retrieving cell contents greater than 255 characters? I have a vlookup function that is properly retrieving the cell, but the text...

I have a spreadsheet that is 3604 rows & 6 columns. Column E has only hyperlinks to URL's. I have filtered my data via column B. I tried to A-Z Column A. When...