Posting Art
New member
i have data in this table
i want result in this formate
i want result in this formate
please help in organize data in excel sheet
- Thread starter Posting Art
- Start date
AliGW
Administrator
- Joined
- Nov 8, 2015
- Messages
- 1,843
- Reaction score
- 8
- Points
- 38
- Location
- Ipswich, Suffolk, England
- Excel Version(s)
- MS 365 (Beta Insider Channel)
Please attach a workbook. Nobody should have to recreate your data when you have it already! 
Posting Art
New member
my file
this is excel file
this is excel file
AliGW
Administrator
- Joined
- Nov 8, 2015
- Messages
- 1,843
- Reaction score
- 8
- Points
- 38
- Location
- Ipswich, Suffolk, England
- Excel Version(s)
- MS 365 (Beta Insider Channel)
We have been informed that this question has been asked on another forum: https://www.mrexcel.com/board/threads/i-want-result-in-this-formate-can-anyone-help-me.1180151/
In future, if you ask questions in other places as well as here, you are required to provide links to those cross-posts, please. This is important. Thanks.
In future, if you ask questions in other places as well as here, you are required to provide links to those cross-posts, please. This is important. Thanks.
Posting Art
New member
Please give me a answer of this question
alansidman
Member
- Joined
- Oct 1, 2018
- Messages
- 402
- Reaction score
- 6
- Points
- 18
- Location
- Steamboat Springs
- Excel Version(s)
- O365
It appears you have an answer at MrE
Posting Art
New member
Respected SIr,
i want when i select drop down then show only selected record not all
can u give me formula to do this instead of vba code?
i want when i select drop down then show only selected record not all
can u give me formula to do this instead of vba code?
AliGW
Administrator
- Joined
- Nov 8, 2015
- Messages
- 1,843
- Reaction score
- 8
- Points
- 38
- Location
- Ipswich, Suffolk, England
- Excel Version(s)
- MS 365 (Beta Insider Channel)
Now cross-posted on five forums.
Alternate approach (Refreshable). see if this helps
https://www.youtube.com/watch?v=mrZJS8LPXpw
https://www.screencast.com/t/rHaynUtvY
https://www.youtube.com/watch?v=mrZJS8LPXpw
https://www.screencast.com/t/rHaynUtvY
- Joined
- Dec 16, 2012
- Messages
- 2,319
- Reaction score
- 40
- Points
- 48
- Excel Version(s)
- 365
I can do this with formulae only.
[video]https://app.box.com/s/qnvltpugnh7ljp74xy2imidvxen9th3a[/video]
Trying to add an animated gif… please be patient!
OK, can't. Grrrr.
Click on the link above it should take you to a gif.
If you like it, paste those pesky cross-post links somewhere in this thread and I'll attach the workbook.
[video]https://app.box.com/s/qnvltpugnh7ljp74xy2imidvxen9th3a[/video]
Trying to add an animated gif… please be patient!
OK, can't. Grrrr.
Click on the link above it should take you to a gif.
If you like it, paste those pesky cross-post links somewhere in this thread and I'll attach the workbook.
Last edited:
Posting Art
New member
@p45cal please solve the issue with formula , please help me
- Joined
- Dec 16, 2012
- Messages
- 2,319
- Reaction score
- 40
- Points
- 48
- Excel Version(s)
- 365
Again, if you like it, paste those pesky cross-post links somewhere in this thread and I'll attach the workbook.
Please read http://www.excelguru.ca/content.php?184
(ps I see my PM box is full - I'll try to delete some)
Posting Art
New member
Posting Art
New member
P45Cal , this file is not working properly, please
- Joined
- Dec 16, 2012
- Messages
- 2,319
- Reaction score
- 40
- Points
- 48
- Excel Version(s)
- 365
What happens? What doesn't happpen?
I don't recognise the 'Excel 2018' you have as your version of Excel in your profile. Could you tell me what your version is? You can find out in Excel in the File|Account menu:
Also, what formula do you see in cell G4?
It should look like this:
Last edited: