Excel function query Closed

Question

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











Configuration: Windows XP / Internet Explorer 8.0

rizvisa1 · Answer

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.

Excel function query

1 response

Similar discussions

Subscribe To Our Newsletter!