LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dan Thompson
 
Posts: n/a
Default I Need Help with complex formula ?

Column "A" Is My Date column Which Starts with Jan 1, 2000
Column "B" Has Generic Data

Now In column "C" row number corisponding to Jan 1, 2001 (Cell "C55")
I have this formula , =IF(ISNUMBER(B55),B55-B54,"")

Now the problem I am having is that when I do a fill down of this
formula Cell "C56" Formula looks like this =IF(ISNUMBER(B56),B56-B55,"")
What I want Cell "C56" Formula to look like is this,
=IF(ISNUMBER(B56),B56-B54,"")
and the next cel should be
=IF(ISNUMBER(B57),B57-B54,"")
ect... ect...and so on.

How can I do this using some sort of fill down so that I don't have to manual
change each formula for every cell, as I have about 5000 cells and that
would take forever.

Thanks in advance for you help
Dan Thompson

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complex =mid formula foff Excel Worksheet Functions 2 August 14th 05 12:32 PM
dragging a formula P Bates Excel Discussion (Misc queries) 3 August 7th 05 09:37 PM
Named SUM Formula with relative refernce(s) Werner Rohrmoser Excel Worksheet Functions 2 April 20th 05 04:56 PM
Cell shows formula and not the result of the formula. stumpy1220 Excel Worksheet Functions 2 January 14th 05 05:11 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM


All times are GMT +1. The time now is 10:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"