I'm having a mental meltdown and can't find the answer in help and can't remember.
1 5k 5k 100 code 10k 10k
5.1K 5.1K 15.1K 15.1K
How do I add F1 to B2 and hold the F1 as constant so that when I drag my formula down, it's F1+B3, F1+B4 et cetera?
Just can't remember. I thought it was =(!f1)+B2 but that isn't working.
Thanks,
Dollar Sign -- $f$1 . If you use $f1 it will hold the column constant and change the row (1.2.3.4...)
In the imortal words of Sheldon
Bazinga!!!!!!
Awesome! Thanks a bunch!
In the imortal words of Sheldon
I see we watch the same show!!
It's about the only show that can make laugh out loud.
5 minutes
> Bazinga!!!!!!
Is this a great site or what...;-)
5 minutes
If you have all your fields in Excel, how do you make
a report?