Hi all
Greetings from Greece
I'm a newbie in xl and my interest is in soccer data
I was wondering is it possible to find the maximum absence of an
example in the data and view its record?
Could this formula be done?
Sorry for my poor English.
Hi all
Greetings from Greece
I'm a newbie in xl and my interest is in soccer data
I was wondering is it possible to find the maximum absence of an
example in the data and view its record?
Could this formula be done?
Sorry for my poor English.
Hi and welcome,
could you upload a little sample book in order to understand layout of your data?
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Hi and thanks for the interest
Well here is the attachment
As you can see at column N there are various scores of several football matches
My goal is to find a specific score lets say 1-0 for example
and search for its maximum absence record and so on for all
possible scores.
Hi - Γεια σας
in Q1 and down
=ROW(A1)-IF(ISERROR(LOOKUP(2,1/($N1:N$2=N2),ROW($A1:A$1))),0,LOOKUP(2,1/($N1:N$1=N2),ROW($A1:A$1)))
in Q6 you'll see first 0 because 1-0 was equal to previous score.
Just for sharing some idea
Hi canapone
Thank for your time and work
As I said before i'm a newbie in excel so the help you gave me is mindblowing to me
This works fine
Thanks again,cheers.
Hi,
thanks for providing kind feedback.
Greetings from Firenze
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks