prioritise

Hi, I've been playing around with various alternative XLOOKUP formulas and INDEX/MATCH to lookup values in a table and return a match - where I want matches that starts with "HTJ" to be prioritised. In other words, if a value is found and starts with "HTJ xxxxx" then use that, if not found...

Hi, I have a spread sheet that is used for storing potential building projects See ( image). I want to get a VBA code that prioritize the projects based on information in the D column, F column and P column. 1. If D contains "Offentlig", F contains either "Skolebygg", "Helsebygg", "Offentlig...

Hi I am working on a priority list and encountered some problems with it. I would really appreciate all the help, thanks. What I am trying to do is to have excel automatically assign a specific number to the Urgency Column based on how many days the item is from the Due Date. <tbody> Priority...

I am wanting to know how to live update a league table so that I don’t have to do it manually with the filter. Team is in column ‘A’, GD is in Column ‘R’ and PTS is in column ‘S’. There are 25 rows including the header row. I was the table to update with 3 priorities. First Priority is PTS in...

Hi all - I think somebody will enjoy working this out:- I have a work spreadsheet that has a list of projects that I am to work on and In column J I prioritise each project 1,2,3 etc. In coulmn D there is data validation and I would like to automatically renumber the priority column the...