Thank you for joining our Excel Reddit AMA today!  ICYMI, check out the lively chat at aka.ms/excelredditama.   If you attended, please fill out this short survey to let us know what you think of this AMA and future AMAs.     ..read more

Come join our next Excel Reddit AMA on March 10 at 10 AM PT!  Goto aka.ms/excelredditama and bring all your Excel questions ..read more

Have some issue to adjust my page to A3 format. Thing is that my options list only shows Letter or A4?     ..read more

I am trying to subtract two excel date/time fields from each other to determine the difference.   the fields are in the format 04/08/2018 23:30 08/08/2018 10:25   I can take ColB away from ColA and get a result if the answer is under 24 hours.  This is not working for my example where the difference is much longer than 24hours.   Has anyone got a formula or suggestion for how to get the correct answer Regards J ..read more

Looking for some help please...   I have a list similar to below where people have sorted a list in an order.   I'd like to count the amount of times the word "A" comes first in all fields, then count the amount of times it appears 2nd etc.   Is there a way of doing this please ..read more

how do I Duplication a page layout on the same worksheet ..read more

Dear all, I have a requirement to copy excel hyperlink urls in group of cells under one column to another column of cells with a formula. The hyperlink on the cell has a display name and when click on the display name then it redirects to the link url. So, I just need to extract automatically the hyperlink url with formulas. Please share your ideas or thoughts on how to extract hyperlink url from one cell to another cell with formula automatically. Thank you for your help and support.   Best Regards, Narayana Reddy ..read more

Hi, How do I copy an Excel Workbook - without losing Formatting/Formulas ..read more

I need to highlight a cell if it remains blank 1 day past date in another cell. For example: I3 has date of 15 May 23. J3 is blank. If today is past date in I3, and J3 is blank, then J3 turns red. If today is before date in I3, then J3 remains the color in the cell as shown in J5 with I5 date of 22 July 23 (that color is based on other conditional formats ..read more

Can anyone help.... i need to create a formula to show the total number of those with 2022, 2023 or blank. Im assuming an IF formula but cant work it out     ..read more