hi guys,
i wanna pull out data from the table by clicking dropdown button in b30.how to do these things?
hi guys,
i wanna pull out data from the table by clicking dropdown button in b30.how to do these things?
hello pejoi,
I think post https://www.excelforum.com/excel-for...ml#post5273235 has the same type of requirement
all formulas used in the sheets are array confirmed with control shift and enter.
The problem in managing the formula is the empty row between the data if details were continuous then I think formulas can be reduced to a larger extent
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
hello pejoi,
I think post https://www.excelforum.com/excel-for...ml#post5273235 has the same type of requirement
all formulas used in the sheets are array confirmed with control shift and enter.
The problem in managing the formula is the empty row between the data if details were continuous then I think formulas can be reduced to a larger extent.
CHECK post #5 for a shorter version of formula in column B and C
Last edited by hemesh; 02-08-2020 at 02:35 PM.
There are several formulas in the file
A shorter version of the formula in B and C from the post#3 can be
Last edited by hemesh; 02-08-2020 at 03:21 PM.
thanks hemesh.
I am glad I could help and thanks for the feedback and rep
Oh
this one
not shorter then mineFormula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Hello BMV, With all due respect , though the formula is shorter and Kudos to you for the same but overall result I think is important, try adding X in the F8:U26 and check the event result .
moreover in row 34 the result in event tab should be 200 instead of 400, similar error will be produced unless it is properly written.
Oh
This one should have been checked!
I have checked and have no problem with result. Can you attach the wrong example?
Last edited by BMV; 02-09-2020 at 05:57 AM.
You could check the same on information provided !
The first Entry should have been with A201 up to 4 times as X is present in events as 100m, 200m, 400m, 4 X 100 m (not produced)
The second entry again is 4 times which is correct but at this junction now entery for events are 100 m 800 m Lompat Jauh 4x 400 m which should be
200m 800 m Lompat Jauh and 4 X 400!
Moreover if I add "X" to different locations then again same thing will take place
check the attached sheet
Last edited by hemesh; 02-09-2020 at 10:53 AM.
hemesh, Thank you, I realy missed one small change in the formula. ROW(a1)-1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks