User Profile
JoshuaHughes1
Copper Contributor
Joined 3 months ago
User Widgets
Recent Discussions
Excel pulls data from Outlook
Hello, We currently have an excel sheet which we access input the previous days date, todays date and hit a button and it shows all the incoming mail into a teams outlook mailbox. This is an old excel sheet we have been using for many years and now i need to do it for newer teams and am unable to work out how this is possible. I've looked online and used co-pilot and unable to find the answers. Attached screenshots below, i thought just changing the hyperlink would work but i think it's more in depth that than. Any help appreciated JoshuaRounding up/down half a pence on excel
Good afternoon, I am needing to round up/down certain columns whilst keeping the formula. I need columns E & F to round up or down depending on the amount, from rows 5,6 7, 8 and 9. Due to the % and the amount some of the answers will include .5 of a pence. I need something that would do the below. 5245.505, the formula will round it to 5245.51. 5245.495, the formula will round it to 5245.49. Any help appreciated. (I left an example in the sheet to show) Thank you JoshuaConditional Formatting Rules
Hello, Is someone able to advise if it is possible to add a rule whereby the below (V & W) Column boxes are only highlighted when a selection has been made on a previous dropdown? Is there a way I can grey the box out or similar? I can do basic conditional formatting but unsure if this falls into it. Thank you in advancePulling data using drop downs
Hello, This may not be possible, but can you input 'Consultant' and 'Month' in the below and it will auto generate the active, completed and closed columns. and it will then be able to pull the data automatically from the below spreadsheet? Using columns A,B and G? So each month i could go into the top sheet and change the consultant and month and it will give me that months overview? Thanks so muchCOUNTIFS Week/Month start error
Hello, I've tried to add a formula which can automatically read data from a spreadsheet and tell me how many appointments i have week to date and month to date once i change the date. It seems to work, however the start date is wrong, it is doing Wednesday to Wednesday instead of Monday to Sunday. Any help appreciated. =COUNTIFS('Annuity Tracker'!G:G,"<=" & B1,'Annuity Tracker'!G:G,">="& B1-(WEEKDAY(B2)-2))
