Search the cell which contains data from range of empty cells

[mubashermukhtar]

I have data sheet in which i want to put the condition to search the cell which have data in it, all other cells in a range are empty. I am talking about here is condition or formula not the filters
Thanks

 

[Peter_SSs]

I'm thinking that nobody here understands what you have or what you want. Could you explain it more clearly and perhaps give some examples to help make it clearer?
Perhaps you could even show us a small example what you have and what you want to end up with?
My signature block below has a link with suggestions for how to do that.

 

[mubashermukhtar]

I'm thinking that nobody here understands what you have or what you want. Could you explain it more clearly and perhaps give some examples to help make it clearer?
Perhaps you could even show us a small example what you have and what you want to end up with?
My signature block below has a link with suggestions for how to do that.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]XYZ[/TD]
[/TR]
[TR]
[TD]here i want to put the condition to search above range and search the cell which have data in it, all other cells are empty except the one[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

1. What range of cells have you shown?

2. What should actually appear in the cell where you have written "here i want to put the condition to search above range and search the cell which have data in it, all other cells are empty except the one"?

 

[mubashermukhtar]

1. What range of cells have you shown?

2. What should actually appear in the cell where you have written "here i want to put the condition to search above range and search the cell which have data in it, all other cells are empty except the one"?

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]ABC[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]ZYZ[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]here i want to put the condition to search above range and search the cell which have data in it, all other cells are empty except the one[/TD]
[TD="align: center"]here i want to put the condition to search above range and search the cell which have data in it, all other cells are empty except the one[/TD]
[/TR]
</tbody>[/TABLE]

There are 2 columns A and B and there are 4 rows. My range of data is A1:A3, in which all cells are empty except one, similarly 2nd range is B1:B3 in which are cells are empty except one. I just want the formula that find the cell which have data and put in the A4 and B4 cell. I hope it will be cleared now

 

[Peter_SSs]

I hope it will be cleared now

Yes it is, thanks.
If you have Excel through Office 365, try the A4 formula copied across. In fact, if only 3 cells, that formula could be =A1&A2&A3
If an older version, try the A5 formula (assuming the non-empty cells contain text, like your samples, not numbers)

Excel Workbook
	A	B
1	ABC
2		ZYZ
3
4	ABC	ZYZ
5	ABC	ZYZ
Get value

 

[mubashermukhtar]

Yes it is, thanks.
If you have Excel through Office 365, try the A4 formula copied across. In fact, if only 3 cells, that formula could be =A1&A2&A3
If an older version, try the A5 formula (assuming the non-empty cells contain text, like your samples, not numbers)

Get value

	A	B
ABC
	ZYZ
ABC	ZYZ
ABC	ZYZ

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:76px;"><col style="width:55px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula A4 =CONCAT(A1:A3) A5 =LOOKUP(REPT("Z",255),A1:A3) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

At last it worked, bundle of thanks....