I am new to this site but am certainly glad I found it!  I have used the
offset and count functions in my formula to adjust my chart which is set in
my pivot table so naturally the data will change as a different filter is
set.  I have gone to Stephen bullen's funchart1.xls... ...

I am attempting to link two large spreadsheets using formulas for each cell.  
I want text, numbers, dates etc. to populate, but if a cell is blank, I want
a blank cell left in the cell.
I have always used =if([Wksht1]Input.xls!A1="","",[Wksht1]Input.xls!A1).  

I am working on spreadsheets that contain 9 colums and anywhere up to 1,500
rows of duplicate information.  I am trying to update my customer bases
pricing for an upcoming price increase.  One customer could only buy 10
different items but purchase those items hundreds of times ...

This is the problem I'm having... Trying to use the IF function...
IF (f7< 20), then i7 - (i7/f7)
if F7 is less then 20 i want it to do the formula, but if F7 is equal to 20
no need for the formla.

I'm trying to change the format of the Find and Replace function so I can see
it easier. I was hoping to set it to highlight the found data.

Hi
I work in a hospital and have to calculate what exact age someone is when
they die.  I have birth date and date of death.  How can I calculate in total
the age on death.  Example,   45 years, 4 months and 5 days

I am facing a problem with the summing of the column data dynamically in the
excel worksheet.
As of now am using the sum function =SUM(BV13:BV14) for that column, but
when the rows grows dynamically, its summing only up to the 1000 rows and

I have 8 columns of data and each row contains the corresponding data.  i
want to automaticaly sort this data using excel funtions preferably not code
so that alll the corresponding data from the row moves, not just one column.
thanks

I've searched in this amazing forum and found a forumla to truncate a
cell length: (assuming data is in A2)
=IF(LEN(A2)>399,LEFT(A2,399),A2 & REPT(" ",399-LEN(A2)))
I'm trimming down text entries in a large spreadsheet where the

I have a spreadsheet that I introduced a macro to eliminate duplications
with ranking formulae in the sheet.
All works ok until after I input data to the sheet,  then run (update
button) the macro.

I'm trying to do a summation of an attendance sheet.  I have an "x" marked
for the fact that they were there, but I don't know how to format that into a
number so I can do a sum and show that they were there this many times.  Any
thoughts?

mycell.offset(0,1).value = Time
mycell.offset(0,1).value = Date
Does anyone have any suggestions on how to assign Time and Date into cell?
Thanks in advance for any suggestions

How can I add consecutive dates on multiple worksheets?  I am trying to
create a workbook for each month of the year with all days include.  Is there
a way to input the dates all at once or do I just have to go through each
worksheet and input the date manually?

I am trying to compare 2 worksheets for similar data. I have serial numbers
in column L on  Sheet1 and serial numbers in column B on Sheet 2. I want to
look for duplicated serial numbers on both worksheets.  I need a formula that
will search both Sheets for any duplicated serial ...

I need help matching two worksheets in the same workbook.
In Ws1 , I have a list of numbers running down column A from A1 to
A5000.
In Ws2 , I have a list of numbers running down column A from A1 to A5000