Hello, Please help me on getting the correct way to lookup a value and return multiple corresponding values. In sheet1 first row, I list out the dates as: 11...

I don't seem to understand how to create a formula that will automatically enter a client's age in years using "TODAY" and their date of birth. I want it to...

I hope you can understand this. I'm trying to set up a spreadsheet in Excel that will show Reg and OT hours. The problem is that some of our employees are...

How do I collate several spreadsheets into one worksheet?

I want to be able to have excel determine last years holiday dates by looking at this years date which is entered in a cell. Example: Cell a1 is where a...

In the formula "=ROUND(Data!G242*0.975*0.5*0.975,0)", if I need to do an edit, replace to eliminate the portion "*.975,0)" and replace that with ",0)", Excel...

I have a simple data table which I am using to better understand GETPIVOTDATA. PivotTable1 contains only 12 rows of data like...

I have one column with various dates.....lets say B2:B20. The next column (C2:c20) with values such as 1, 4, 8, etc. I am trying to calculate the earliest...

I have three worksheets to embed into a document. The last column of cells in worksheet1 must repeat as the first column in worksheet2. The last column of...

Hi Everyone, I found this code which is perfect for what I need to accomplish except it doesn't do Formulas. i.e. Vlookups or direct links to...

This seeems like it should be a simple thing to do but I can't make it happen. I have a column of 100's of data points. I want to check they symmetry of the...

Hey I'm looking for a way to sum rows but ignore the adjacent rows which are hidden. excel is adding the stuff in the unhide rows (which is what i want) but...

I am using a text formula in a Macro to convert numbers to text. Some of the numbers will be 5 digits and some will be 6 digits. How do I count the number...

How can I prevent excel from counting entries twice when totaling date ranges. I am using the following formula: January Total Cell ...

I have a workbook with two sheets. On the first sheet are a series of dates. On the second tab, I am trying to total the number of entries within specific...

I have a workbook with two sheets. On the first sheet are a series of dates. On the second tab, I am trying to total the number of entries within specific...

Does anyone know how I can convert a 13 digit ID number to a 9 digit ID number by dropping the 4 zeroes off the end? Example: 1234567890000 to look like...

In Excel 2007 How do I get the formula: =large(a1:a9,6) to return negative numbers, I only get positive.

I have a spreadsheet with 2600 items (cells). I need a simple formula in one column, say N, that multiplies column H X Column I: i.e., =H2600*I2600. Can i do...

I have a long list of customers. Each of them have a unique pricing formula associated with their account. On my "Tab1," I have written formulas to return...