formula required

Hello, I have a running monthly total of sales. I type the value in Column L. I have a formula which finds and returns the most recent entry. That formula is LOOKUP(2,1/(L2:L13<>””),L2:L13). In column K is the corresponding month, Jan-Dec. What I would like is for excel to find the most...

Hi, I'm trying to create an excel spreadsheet (version 2019 and no ability to upgrade to 365) to keep track of appointments. There are sheets for each month. And I need the appointments for future dates to show up in their respective monthly tab automatically (without disappearing from the...

Hi, I have a question, I am a teacher and I have been sent students mock exam answers in excel. The way they are presented are as a sequence of numbers, every number in the sequence that is correctly placed gains the student a mark. The correct answer is also inversed so 9,8,7,6,5,4,3,2,1 would...

Hi, I have two tables first one is showing number of involuntary resignations each month during 2017, 2nd table resignations during 2018 for locations A,B,C,D,E, F, 3rd table shows the total headcount by month for 2017, and last table is headcount for 2018. My question is: how to calculate...

Hi, Could anyone advise with a basic formula that will "flag" up if entry in column b is equal to or more than entry in column a A B Comment 1 2 Yes 2 1 No Thanks for any help and guidance in advance.

Hello Folks, I have a requirement to extract the domains from a list of URLs. I know this is quite trending and a petty common topic across generic internet search, however no formulas quite seem to match my specific query. My file has a list of domains (which include subdomains and multiple...

Hi, I would be most grateful if someone could assist me of the attached spreadsheet. I need for column E (Latest % Com) to tell me the latest % entered on that row, however I do not want the search on the day hours just the percentage only columns. So for example for the formula im looking for...