Search results

Thanks.

In a worksheet, I have random unique digits in the range B4:G26. Now I want to display in the range B28:G50 the 10 largest digits from the range B4:G26. The other (smaller) digits should be converted to 0 or to an empty cell. Colors are just for the example Thanks

It would be nice if I could achieve this. the treatment of multiple coincident maxima. I use O365, but my friend works with O2021

@Peter Bartholomew , Only the first formula works, but I don't get multiple coincident maxima The other 3 give errors.

Works perfect. Thanks.:) :)

I have this formula =MAX(C2:C71) but i want combine it with an offset formula. In a cell i have this max formula, but in the cell above i want to add the the name that belongs to the max result, these names are in column B Thanks

Example

Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target, Range("A1")) Is Nothing Then MsgBox "Maak eerst je keuze in cel A1", vbExclamation, "Cel A1 is leeg" End If End Sub

@ MarcL, thank you for your code, works perfect.

Can you give what more explenation, afther beiing in the hospital for almost a year, i lost a lot of my knowledge. I just want to help a friend with his fishing competition.

+ ? is a typo, it should be +1

Case Is = 1 T_00.Value = WorksheetFunction.Max([Nr_1]) + 1 Case Is = 2 T_00.Value = WorksheetFunction.Max([Nr_2]) + 1 Case Is = 3 T_00.Value = WorksheetFunction.Max([Nr_3]) + 1 Case Is = 4 T_00.Value = WorksheetFunction.Max([Nr_4]) + ? Case Is = 5...

It looks as the result that I want GrathH Thanks. :)

Example

=IF(E1="C purchased" to =IF(E11Like"C purchased" How to change?

Happy dreaming.

I don't understand the question anymore that's what happens when you click in the cell. Why, you can't have 2 ore more hypelinks in one cell. What do you want to accomplish

Something like this? Hyperlink in C10

does this help? https://www.exceldemy.com/drop-down-list-in-word-from-excel/

Glad to help. :)

What about this?

Thanks p45cal, works perfect. @ vletm, sorry for the mistake, my bad.

=IF(EXACT(A2,UPPER(A2)),"Upper Case",IF(EXACT(A2,LOWER(A2)),"Lower Case","Upper and Lower Case")) Now I get Upper Case when cell is empty.

Good luck with this set up. Suc6

Something like this?