• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Return non blank cell value and respective another given cell value

Sguna1982

Firstly, Welcome to the Chandoo.org Forums

I would add a column
G2: Check
G3: =COUNTA(C3:F3)>0
Copy G3 Down
Sort the data
Delete the blank rows
 
Hi Guna ,

There are no formulae in column G ; the formulae are in columns H through M , based on a helper column Q.

The formula in column Q is listing the row numbers of the entries in the database columns C through F ; the formulae in columns J through M check whether the entry corresponding to the row number in column Q comes from the columns C through F ; if it comes from column C , then it is put in column J , if it comes from column D , then it is put in column K , and so on.

The date entries are very simple , since if there is an entry in any of the 4 columns , the corresponding date has to be put in.

Narayan
 
Thanks Narayanan,

Again I have attached my exact excel workbook, while i am trying to put same way like your formula its not working. Please help me to get that resolve.

Regards,
Guna.S
 

Attachments

Narayan,

I found in the excel sheet formula in coloumn Q, that is =SMALL(IF(Data<>"",ROW(Data)-MIN(ROW(Data))+1),ROWS($A$1:$A1)), in this i am not able understand what is data refering, due to this only the formula is not working in another excel sheet. Please help.

Guna.S
 
Hi Guna ,

See this file.

One more helper column has been added , since in your original file , multiple columns did not have entries in the same row.

The name Data refers to a named range ; it is not so important , just a way to enter formulae easily. You can replace all references to Data by the absolute range reference ='PUNBD-1'!$C$3:$O$95.

Narayan
 

Attachments

You must log in or register to reply here.
Back
Top