Reading RPLS is free for the whole profession. Members post, reply, and get the members-only rooms.
Notifications
Clear all
Strictly Surveying
6
Posts
5
Users
0
Reactions
1,030
Views
Topic starter
Translate
▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
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,
Posted : November 8, 2011 1:57 pm
Translate
▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
Dollar Sign -- $f$1 . If you use $f1 it will hold the column constant and change the row (1.2.3.4...)
Posted : November 8, 2011 2:02 pm
Topic starter
Translate
▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
In the imortal words of Sheldon
Bazinga!!!!!!
Awesome! Thanks a bunch!
Posted : November 8, 2011 2:04 pm
Translate
▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
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.
Posted : November 8, 2011 2:31 pm
Translate
▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
5 minutes
> Bazinga!!!!!!
Is this a great site or what...;-)
Posted : November 8, 2011 2:44 pm
Translate
▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
5 minutes
If you have all your fields in Excel, how do you make
a report?
Posted : November 8, 2011 11:00 pm