Hi!
I got a problem with attached file. Øvningsark.xlsx I need to calculate the max number i C for each Cpr (A). I tried =+MAX(IF($A$3:$A$50=A4;$C$3:$C$50)) - but it didn't work for every line. Just for 60% of it..
Anyone has an idea?
Thanks
Jen
Hi!
I got a problem with attached file. Øvningsark.xlsx I need to calculate the max number i C for each Cpr (A). I tried =+MAX(IF($A$3:$A$50=A4;$C$3:$C$50)) - but it didn't work for every line. Just for 60% of it..
Anyone has an idea?
Thanks
Jen
Hi
get rid of the merged cells in col A and enter the values cell by cell. That should solve it
( and forget about merged cells in the future except for cosmetic purposes)
The main problem is the merged cells in column A. In any cell other than the "top" merged cell, Excel finds a value of zero and then gives the wrong answer. CAn you get rid of the merged cells (they're a TOTAL disaster in most circumstances)? The formula also needs to be entered as an array (with CTRL-SHIFT-ENTER, not just ENTER).
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Here's a way using a helper column (which could be hidden).
Get rid of the merged cells.
After that run this VBA code to fill the table.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thx a lot all of you! Really helpful! Have a nice day :D
Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks