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
768
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.