user1

Hello I tried many combinations of formulas but every time first and second highest value is the same im getting first key for both. DATA <tbody> # A B C 1 1 USER1 8 2 2 USER1 8 3 3 USER1 4 4 4 USER2 5 </tbody> Display <tbody> # A B 1 [find key [DATA A:A] of first highest value...

Hi, I'm making a "userdatabase". My exceldocumenct contains these sheets: Overview - Will automatically look through User1 to User150 to make some graphs. Users - A list with all users User1 - The database with userinfo User150 - The database with userinfo Template - The database template for...

Hi This is me first time posting on this forum, so hoping someone can answer. I have data in the below sample format. I am trying to get a record count when the values in column 1(Week) and column2 (Name) match together. For example, User1 has three entries for 7/14/2018. So in column3, I...

Hi Everyone, I have a table where it shows logs of different users working on a claim. I want to be able to create a pivot table but the count on the "Status" field should satisfy two conditions. For this scenario, I want to count the "Pending" status for User1. For User1 to have a count, User1...

I'm having trouble locking a range of cells if a VBA password prompt does not enter specific user names into a cell. I want any users to be able to edit range A1:I11, but I only want 2 specific users to be able to edit anything else on the sheet (codename sheet1). The user's name is determined...