Excel Question
01 March 2006, 10:50 AM
#1
Scooby Regular
Thread Starter
Join Date: Dec 2000
Posts: 754
Likes: 0
Received 0 Likes
on
0 Posts
Excel Question
Just a quick one...
I have a spreadsheet with a column of data containing either "N" or "Y" depending on whether they fulfill certain criteria. Having completed all of the "N's", can someone tell me what code I can use to autofill the blanks with "Y"?
K.
I have a spreadsheet with a column of data containing either "N" or "Y" depending on whether they fulfill certain criteria. Having completed all of the "N's", can someone tell me what code I can use to autofill the blanks with "Y"?
K.
01 March 2006, 11:11 AM
#2
Originally Posted by kelvin
Just a quick one...
I have a spreadsheet with a column of data containing either "N" or "Y" depending on whether they fulfill certain criteria. Having completed all of the "N's", can someone tell me what code I can use to autofill the blanks with "Y"?
K.
I have a spreadsheet with a column of data containing either "N" or "Y" depending on whether they fulfill certain criteria. Having completed all of the "N's", can someone tell me what code I can use to autofill the blanks with "Y"?
K.
Then click replace all
01 March 2006, 12:07 PM
#3
Scooby Regular
Thread Starter
Join Date: Dec 2000
Posts: 754
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by bob269
Highlight the column or area where your data is, then simply use find/replace. Leave the find box empty and replace with Y
Then click replace all
Then click replace all
Nice one, thanks. Trust me to try and do it the complicated way!
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
Brzoza
Engine Management and ECU Remapping
1
02 October 2015 05:26 PM