Hello Everyone , Can anyone help me how to het this result , which formula i need to use ?
Capture.PNG
Hello Everyone , Can anyone help me how to het this result , which formula i need to use ?
Capture.PNG
Last edited by AliGW; 06-30-2019 at 05:50 AM.
I don't know if a formula will help you with this, I think you're better off with a macro function which you can then place in a formula
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Your profile says that you're using excel 2003, but your screen capture is not even excel!
Given that we don't know which application, or which version of that application that you are actually using, we have no way of knowing what to suggest that will work.
This array formula works for me, but noting the above, it may not work for you....confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.Formula:Please Login or Register to view this content.
Hi Sir , this is a google spreadsheet , can you please chceck in the below link ?
https://docs.google.com/spreadsheets...it?usp=sharing
Google Sheets is NOT Excel
but we can apply formulas into that right?
You can try the formula that I suggested, that is as much help as I can offer, I don't use google sheets.
I'll submit a request for your thread to be moved to the correct forum, where someone who does use google sheets might be able to help you.
Thank you soo much Sir, i tried ur formula but unfortunately, its give error.
Moved to the other platforms section.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You can use formulas but they must be Google Sheet formulas
You need concatenate rather than concat. In J4:
=ArrayFormula(CONCATENATE(IF(INDEX($B$4:$F$9,MATCH(H4,$A$4:$A$9,0),0)<>"",$B$3:$F$3&":"&INDEX($B$4:$F$9,MATCH(H4,$A$4:$A$9,0),0)&CHAR(10),"")))
and copy down.
Rory
Thank you soo much
Works Perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks