ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   display.. help (https://www.excelbanter.com/excel-worksheet-functions/196831-display-help.html)

Angel

display.. help
 
For instance:

Company XX 10% A owes 5.1 Loan A
20% B owes Loan B
30% C owes

Company YY 60% A owes 4.1 Loan A
10% B owes Loan B
20% C owes

when i sort the data, say like Column A (by company), when I choose "Company
XX", only the first row appears of Company XX appears, as follows

" Company XX 10% A owes 5.1 Loan A "


Can i set anything so that, when i sort the data, all information about
company XX will appear?

My desired result is

"Company XX 10% A owes 5.1 Loan A
20% B owes Loan B
30% C owes "

Thanks




All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com