Master spreadsheet to collate blank cells

ELEANOR1690

New Member
Joined
Sep 5, 2018
Messages
11
CMRECJV
1051154127
1051254128
1051354129
1051454130
1051554131
1051654132
1051754133
1051854134
1051954135
1052054136
1052154137
1052250233
1052350234
1052450241
1093250244
2240750245
2721150246
2721250247
2721350248
2721450249
2721550250
2721650251
2721750252
2721850287
2721950288
2722050289
2722150290
2722250291
2722350292
2722450303
2722550305
2722750309
4746550310
50311
50312
50313

<tbody>
</tbody>
I have daily worksheets as above what I would like to do is collate the cells that do not contain √ and report the out put with the data in the cell to the left, for example from the above B7 is blank therefore it should report 10516 but for each daily sheet
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,005
in a helper column put row number for the non ticked cells, then use an offset formula with large(B2:b100,1) etc, maybe...
 

Watch MrExcel Video

Forum statistics

Threads
1,122,893
Messages
5,598,712
Members
414,254
Latest member
MarieCo

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
Top