ExcelBanter - Worksheet to Worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Worksheet to Worksheet (https://www.excelbanter.com/excel-worksheet-functions/237252-worksheet-worksheet.html)

Yoli

Worksheet to Worksheet

In worksheet 1, I have:
A B C
27 1.5 text
15 1.0 text
27 .75 text

In a cell in worksheet 2, how do I get all the text in column C that only
relates to number 27 in column A?

Teethless mama

Worksheet to Worksheet

Take a look this site:

http://www.contextures.com/xlVideos04.html#AdvFiltSheet

"Yoli" wrote:

In worksheet 1, I have:
A B C
27 1.5 text
15 1.0 text
27 .75 text

In a cell in worksheet 2, how do I get all the text in column C that only
relates to number 27 in column A?

All times are GMT +1. The time now is 08:23 AM.