Excel function query [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I want your help for calculating the balnk cell in the row in a particaular cell and paste the top row column value in that cell.

Means which cell are balnk as described below.



Cloumn Name--> A B C D E F
ROW -->1 1st 2nd 3rd 4th 5th 6th
2 p p p p
3 p p



Now

In want to count blank cell in this table in a particular cell. that easy to count but i want count the blank cell and paste the value of which are exist in row 1

Basically i want sloution of this type.



in particular cell value should appear as in

row no 2 = 2nd,4th,
row no 3 = 1st, 3rd, 5th, 6th











1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
Could you post a formatted table to see what value is where

you could use some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!