Create a formula to use in a report that enters only players in order of finish (only Prize winners by Rank).
See attached File
Create a formula to use in a report that enters only players in order of finish (only Prize winners by Rank).
See attached File
formulas entered in the cells are array entered such formulas are entered by holding control and shift together and then by hitting enter
Last edited by hemesh; 02-17-2020 at 08:19 PM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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
Thank you so much...this is exactly what I was looking for - very nice solution.
Thanks for the feedback
I needed to make a change in the sheet layout ... I need to have the new report reference the table in cells J24:N25; I just can't seem to adjust your formula to accomplish this report.
Thanks in advance - see attached file
try using below in J29
Formula:Please Login or Register to view this content.
Hemesh...thanks for the speedy reply...unfortunatelSy I can't seem to apply this to the above sheet. I need the report (Sample Report 2 - cells K28:N34) to return the same results as shown in cells B5:E11, however we need to use the $ values from cells J24:N25.
find attached is this you are looking for!
Hemesh...I need Sample Report 2 to look the same as Sample Report (A5:E11 format and layout only) - Use the same data (A13:G34 and Prize $ Table J24:N25) - the original solution worked perfectly, unfortunately I need to create a new sheet using the Prize $ table J24:N25 and data form A13:G34 (the new formula can't reference the original Sample Report). Thanks for your patience.
find attached !
Hemesh...the Results as shown in original Sample Report are correct - formulas work and results are perfect. The results in your last reply are incorrect. Can we use the same formulas as original, but use the Prize table in cells J24:N25? Sorry for all the confusion.
hello CRJ, I am leaving now for some work, will do it once I am back , can you upload a sample showing how you want to do it in another sheet. And in sheet 1 there is practically no change in results
Hemesh...here you go
are you looking for this , check attached
Hemesh...sorry for all the confusion - The formula logic in G20:G38 is incorrect, i.e., Player 4 and Player 9 are tied for 1st place (Prize $'s are split - (8 + 6)/2 = $7 awarded to both Players)...see the original formula logic - the only change that I was hoping to make is to use the Horizontal Table B7:F7 in place of the original Vertical Table J20:k25.
in g20; copy paste below
and drag downFormula:Please Login or Register to view this content.
Perfect...thanks soooooo much for your patience - I appreciate all the time you spent on this - I'm very grateful
You are Welcome ! if that takes care of your original question then mark the thread as solved by going to thread tools.
Last edited by hemesh; 02-20-2020 at 10:19 AM.
Hemesh...you did such a great job on my last challenge that I thought of you with the below problem.
See Attached File - If a Team is Ranked, Name, Team Gross Score and Team Prize need to be transposed (formula only - no vba code or macros) to the print preparation area.
I've tried the Transpose function - to much user intervention.
Hello CRJ,
In uploaded file I have added a helper column and deleted everything below Row 28 in B29 copy paste below and drag down
Formula:Please Login or Register to view this content.
In C29 copy paste below and drag down
Formula:Please Login or Register to view this content.
In D29 copy paste below and drag down
Formula:Please Login or Register to view this content.
Hope this take care of your question if so then mark the thread as solved and you can also thank contributors by clicking little star button at the bottom left corner of their post !
Last edited by hemesh; 02-29-2020 at 12:23 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks