Previous Topic Next Topic

Excel function query

Closed
Surender Singh - May 31, 2010 at 06:39 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 31, 2010 at 07:16 AM
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











Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 31, 2010 at 07:16 AM
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.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses