Index collumn projects to rows matching if blank or not (1).xls
On column G i search for the project that an agent worked the most based on column % timp alocat (I, M, Q, U and so on)
Bring the header Column row 1(H, L, P, T, X and so on) for the project results.
I put the desired results inside comments on g3,4,5,6
The formula that i have used with the help of ALIG works with lookup if you don`t have percents and multiple text. So i need another adapted one. As far i can`t find one on my self.
Alex
without knowing what will go in Cols J:K, N:O etc, and assuming XL2010, you could try:
Formula:
Please Login or Register to view this content.
Please - I am NOT AliG! I am AliGW.The formula that i have used with the help of ALIG ...
Try this:
=LOOKUP(2,1/($I3:$CB3<>"")*($I$2:$CB$2="% timp alocat"),$H$1:$CA$1)
Last edited by AliGW; 06-13-2023 at 02:46 AM. Reason: Workbook added.
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.
Omg sorry Ali your name is so close to that actor Sasha Baron that plays AligSo my mistake.
I think your name contain abbreviations. A big mistake for me so sorry again ALIGW
I may preffer ALi if you don`t mind
And thank you kindly for your always good and precise reminders for me about the rules.
Sometimes i`m in such a rush that i don`t know exactly what rules i strike but step by step i have to say i become better about this.
Thanks for all!
Originally Posted by alexxl
FWIW, this method will return the header value associated with the last % entry not (necessarily) the predominant entry; in the sample the two are the same however, I suspect that in reality this is not going to be the case.
That's fine! Apart from anything else, AliG is male, but I am female!!!I may preffer ALi if you don`t mind ).
That`s a correct remark but what if i have information in near 2 collumns after % timp alocat example collumn AH, AI.
With your index formula it`s ok only if i have blanks in those collumns and i didn`t anticipate this.
Could you make reffer only to the %timp alocat collumn?
I made a corection to my previous file please take a look. Actualy this is my corect problem.
Index collumn projects to rows matching if blank or not.xls
Last edited by alexxl; 06-16-2023 at 07:44 AM.
I think @Ali forgot to add parentheses.
Please Login or Register to view this content.
It`s not working as i wishh !
Please, upload a sample file to describe.
Look at my 7 point!
Well, SHOW us how you want it to work, then!!!It`s not working as i wishh !
Explain what the 'predominant' item is.
Hidroelectrica does NOT have the highest pecentage in timp alocat!
Last edited by AliGW; 06-16-2023 at 08:36 AM.
About you attachement in Post #7, the result is Hidroelectrica. Why is not the Raiffeisen? the rule is ?
Thats what I've just asked - it does not seem to follow alexxi's own rules. Difficult to help when that happens ...
I noted in the file of #7 the result is Adservio! maybe you look at a different file. or you read the comment (sorry for that comment i forgot about it)
In the file you clearly stated this:
!!!!I put the desired results inside comments on g3
We aren't psychic - we don't know that you don't mean that any longer.
Yes sorry my bad
Try this
maybe, you should committed with Ctrl+Shift+Enter.Please Login or Register to view this content.
Last edited by windknife; 06-16-2023 at 09:39 AM.
Do you even know what this means to me? Thank you very much!
You are welcome.
I have modified the answer to find the first maximum value, if data have many maimum value.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks