LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 29th 21, 07:16 AM
Junior Member
First recorded activity by ExcelBanter: Sep 2015
Posts: 5
Default help for a typical basic formula one summary list @ cells B24,B25,B26;B27

hi all,

greetings. just posted now since 12 years ago for a refresher.

xlsx 2016
below is my sheet 1
Col(A ) Col(B ) Col(C ) Col(D ) Col(E ) Col(F )
Row(1 ) TABLE (S/N) status beer vodka whisky brandy
Row(2 ) P0102 good condition whisky
Row(3 ) P0103 good condition vodka
Row(4 ) P0104 good condition beer
Row(5 ) P0105 good condition vodka
Row(6 ) P0106 under repair
Row(7 ) P0107 good condition whisky
Row(8 ) P0108 under repair
Row(9 ) P0109 good condition beer
Row(10 ) P0110 good condition whisky
Row(11 ) P0111 good condition vodka
Row(12 ) P0112 under repair
Row(13 ) P0113 good condition whisky
Row(14 ) P0114 under repair
Row(15 ) P0115 good condition brandy
Row(16 ) P0116 good condition beer
Row(17 ) P0117 under repair
Row(18 ) P0118 good condition vodka
Row(19 ) P0119 under repair
Row(20 ) P0120 good condition whisky
Row(21 ) P0121 under repair
Row(22 ) P0122 good condition brandy
Row(24) beer P0104 ,P0109 ,P0116.
Row(25) vodka P0103 ,P0105 ,P0111 ,P0118.
Row(26 ) whisky P0102 ,P0107,P0110,P0113 ,P0120.
Row(27 ) brandy P0115 ,P0122.

sample result for B26 contains the merged list of data from col (A) which has a row of whisky intersecting with col (E).
e.g. B26 "=" P0102 ,P0107,P0110,P0113 ,P0120. as quick result from the desired formula


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Basic file, data only once to summary? NeedToKnow Excel Discussion (Misc queries) 2 November 11th 09 01:16 PM
Formula for list summary Sinner Excel Discussion (Misc queries) 2 February 14th 08 01:22 PM
Formula for list summary Sinner Excel Programming 1 February 13th 08 02:54 PM
Creating A Breakout List from a Summary List? cardan Excel Programming 1 September 7th 06 12:41 AM
copying vis basic formula in multiple column/cells kmf Excel Programming 1 October 27th 04 01:30 PM

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

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017