Need function or formula to fill in blank cells in column N with Column O

SOLTEC

SOLTEC

Board Regular
Joined
Feb 11, 2015
Messages
195
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
I need a formula or function to populate column N from column O if there is a 1 or blank.


Excel 2010
NO
191045.jpg;1046.jpg;1047.jpg;1048.jpg1048.jpg
201051.jpg;1057.jpg;1058.jpg;1059.jpg1051.jpg
211051.jpg;1057.jpg;1058.jpg;1059.jpg1057.jpg
221051.jpg;1057.jpg;1058.jpg;1059.jpg1058.jpg
231051.jpg;1057.jpg;1058.jpg;1059.jpg1059.jpg
241060.jpg;1061.jpg;1062.jpg;1063.jpg;1064.jpg;1065.jpg;1066.jpg;1067.jpg;1070.jpg;1071.jpg1060.jpg
251060.jpg;1061.jpg;1062.jpg;1063.jpg;1064.jpg;1065.jpg;1066.jpg;1067.jpg;1070.jpg;1071.jpg1061.jpg
261060.jpg;1061.jpg;1062.jpg;1063.jpg;1064.jpg;1065.jpg;1066.jpg;1067.jpg;1070.jpg;1071.jpg1062.jpg
271060.jpg;1061.jpg;1062.jpg;1063.jpg;1064.jpg;1065.jpg;1066.jpg;1067.jpg;1070.jpg;1071.jpg1063.jpg
281060.jpg;1061.jpg;1062.jpg;1063.jpg;1064.jpg;1065.jpg;1066.jpg;1067.jpg;1070.jpg;1071.jpg1064.jpg
291060.jpg;1061.jpg;1062.jpg;1063.jpg;1064.jpg;1065.jpg;1066.jpg;1067.jpg;1070.jpg;1071.jpg1065.jpg
301060.jpg;1061.jpg;1062.jpg;1063.jpg;1064.jpg;1065.jpg;1066.jpg;1067.jpg;1070.jpg;1071.jpg1066.jpg
311060.jpg;1061.jpg;1062.jpg;1063.jpg;1064.jpg;1065.jpg;1066.jpg;1067.jpg;1070.jpg;1071.jpg1067.jpg
321060.jpg;1061.jpg;1062.jpg;1063.jpg;1064.jpg;1065.jpg;1066.jpg;1067.jpg;1070.jpg;1071.jpg1070.jpg
331060.jpg;1061.jpg;1062.jpg;1063.jpg;1064.jpg;1065.jpg;1066.jpg;1067.jpg;1070.jpg;1071.jpg1071.jpg
341072.jpg;1073.jpg;1074.jpg;1079.jpg1072.jpg
351072.jpg;1073.jpg;1074.jpg;1079.jpg1073.jpg
361072.jpg;1073.jpg;1074.jpg;1079.jpg1074.jpg
371072.jpg;1073.jpg;1074.jpg;1079.jpg1079.jpg
381091.jpg;1092.jpg;1093.jpg;1094.jpg1091.jpg
391091.jpg;1092.jpg;1093.jpg;1094.jpg1092.jpg
401091.jpg;1092.jpg;1093.jpg;1094.jpg1093.jpg
411091.jpg;1092.jpg;1093.jpg;1094.jpg1094.jpg
421095.jpg;1096.jpg;1097.jpg;1099.jpg1095.jpg
431095.jpg;1096.jpg;1097.jpg;1099.jpg1096.jpg
441095.jpg;1096.jpg;1097.jpg;1099.jpg1097.jpg
451095.jpg;1096.jpg;1097.jpg;1099.jpg1099.jpg
4611101.jpg
471102.jpg;1103.jpg1102.jpg
481102.jpg;1103.jpg1103.jpg
491104.jpg;1115.jpg1104.jpg
501104.jpg;1115.jpg1115.jpg
511120.jpg;1121.jpg;1124.jpg;1125.jpg1120.jpg
521120.jpg;1121.jpg;1124.jpg;1125.jpg1121.jpg
531120.jpg;1121.jpg;1124.jpg;1125.jpg1124.jpg
541120.jpg;1121.jpg;1124.jpg;1125.jpg1125.jpg
551146.jpg;1147.jpg;1148.jpg1146.jpg
561146.jpg;1147.jpg;1148.jpg1147.jpg
571146.jpg;1147.jpg;1148.jpg1148.jpg
5811149.jpg
591185.jpg;1186.jpg;1187.jpg1185.jpg
Sheet1
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
A formula INSIDE Column N won't be possible, since Column N holds the 1 to use.
If you use a helper column, you can rebuild a Column N, so to speak

This will return the value in Column O if Column N is Blank or 1.
If Column N is not Blank or 1, it will simply return the value in Column N:

Code: 
=IF(OR(N1="",N1=1),O1,N1)

If you would rather not use a helper column, then a For Each loop in VBA, or a Filter in VBA will probably be better.

Hope this helps.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Check if specific date has been used and if yes choose first next available date
Replies
8
Views
590
CaraEL
C
C
  • Question Question
Can someone help me figure out why this macro is skipping some cells (Conditional Formatting)?
Replies
9
Views
702
Coyotex3
C
J
  • Solved
How can I simplify this HYPERLINK formula?
2
Replies
14
Views
835
jmpatrick
J
J
  • Question Question
Excel macro for Remove comma's and spaces from a cell and place the data in different cell
Replies
3
Views
1K
JEC
JEC
B
  • Question Question
average based on time
Replies
1
Views
385
baqer
B

Forum statistics

Threads
1,223,228
Messages
6,170,874
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top