I need to determine if a numeric value held in a cell exists is a multy row, multy column array of numeric values -- Regards. Glynn Taylor

how can I show viewers the audit trail arrows in a saved filed? say, when I email an excel file, I want the recipients see the audit trail arrows when they...

Hi all, I have a routine in Excel VBA that pastes the unicode content of the clipboard on the active worksheet. The line is simply...

Help please! I'm a beginner here and I have a working sumif function to which I need to add a second condition. This second condition is to only sum if the...

I am looking to total up the same cell from multiple worksheets within a workbook. For instance, if I have 10 worksheets (one being the summation...

I have a worksheet that has 50 rows of data on it and I wanted to create seperate sheets for each row of data. Is there an easy way to do this or do I have...

Good day, I have this: =MID(CELL("filename",A1),FIND("",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) But how can I get the name of the Workbook in...

I want to compare/match data from two 1,000+ row spreadsheets where the values are similar but not exactly alike. For example, on one spreadsheet I have a...

I have an excel file that has validation set up to choose numbers from a list. In the column next to the numbers, I have a description of what the numbers...

I've recently added a combo box to a worksheet for the use of auto complete in drop-down lists. I've now added another column that has the same properties,...

Column B has Department Names Column C has the department codes, the department codes are the headings of columns F-H. What formula can I set that will read...

I have dates of birth entered into a column as 41384 which I would like to insert the "/" symbol so that the dates read 4/13/84. The month never includes a...

I have ~3000 lines of data. Column D includes an incident date for data collected over the entire current year. Column E includes an incident type (there...

i'm trying to check within a range (u5:ab94) if there are values based on the content in column A to identify if there is activity but it only return a 1...

NOT(ISERROR(SEARCH("DLL",C1))) is how I evaluate a single cell I want to sum all adjacent values in D:D if the value in C:C has DLL anywhere in the text. I...

I am trying to get a function to look backwards through a list to match two text strings, then return a value that corresponded to the last entry. Example ...

Have invoices and their dates and customer names. Looking for a formula to tell me how many invoices were cut for that customer for the year 2008 Col V is...

In Excel, I am looking for a formula to apply a sliding scale price markup using interpolation. The size of the percentage markup would decrease as cost...

Hello, I would like to count sum of numbers if there is a condition, for example Column A: Product RADIO Product CELL PHONE Product RADIO Product RADIO

Say I have these set of lists in different cells. After a user has selected data from each cell, he clicks on a link to check whether or not all selected...