Question on a type of text linking between sheets
Hi, I'm trying to work out how I would copy text live from one sheet to another. Essentially what I'm trying to do is create a meeting minutes template that automatically puts yesterday's actions onto today minutes without having to copy and paste it. Only condition to end this (and to prevent it pasting across all days of the month) would be crossing it out with ctrl+5 once the action has been completed. The setup I have is a sheet for everyday of the month, each with their own actions box on identical coordinates. It's not the only thing on the sheet but it's the bit I'm trying to make easier. Is there any way I could do this? I'm not particularly experienced in excel so I'm hoping it's not too complex. Image of the actions section plus sheets.
Graphing Multiple Series on one Graph
SampleSheet Hello all, I have been asked to Graph a variety of different data series into one graph to see if any may relate to each other. The graph is intended to be a line graph, having 5 different lines, representing 5 different data series. I believe this is possible, but just cannot remember how to do it. An issue that I'm having is that the Data series has such different values, ranging from a series having values of <1.0 to series having values of >20,000. Is it possible to have a 'break' in the y-axis so that the gap between say... 100 on the y-axis to 20,000 on the y-axis is non-existent or would it be recommended to just add a secondary Y-axis for this series? The dates are of significance, and should be on the x axis to show the timeline of these different values. Any help here would be appreciated as my direct report has been asking this of me, and we're both stumped. I've attached a spreadsheet with the 5 series included. Is anyone able to have these 5 series added to the same line graph in a legible manner without adjusting their values? Thank-you so much in advance. ToonChart doesn't update its range when recalculate happen when the file open
Reproducible Steps: Set formula =SEQUENCE(SECOND(NOW())), and create a chart. It is a dynamic array, so the chart's range should update when the array change Close and open the file. The array change when open, but the chart stands the range before
Sharepoint Hyperlink not Dynamic
Recently a bunch of items were moved from a drive to Sharepoint and I am trying to update my dynamic hyperlinks. Every month there is a checklist of tasks that need to be accomplished and I have Hyperlink formulas to click on and go to the current month-year folder. I setup my formula using the "December 2024" folder as my basis and the formula sent me there. Perfect! Then I changed the MONTH_YEAR cell to "December 2023". The only difference between the file paths when copied and pasted from the address bar is 2023 versus 2024. When I clicked on the updated link it sent me right back to the 2024 folder. Does anyone know why the link isn't changing when I change the parameters? =IFERROR(HYPERLINK(CONCAT(http_to_Master_Folder, "%2F%5F%5FCharacter%2FCY", RIGHT(MONTH_YEAR,4), "%2FNotes&viewid=x00000f2%2X0x0x%2XD0xxx%0Xx00x%0X0000x000xx00"), CONCAT("Game > Campaign > Player > Character > CY", RIGHT(MONTH_YEAR,4), " > Notes")), CONCAT("Game > Campaign > Player > Character > CY", RIGHT(MONTH_YEAR,4), "> Notes")) Thank you
XLOOKUP when lookup value may be text string or number formatted as text
I have a data set that has lookup value which may be text string or number formatted as text, with the lookup range formatted General. How can I format the lookup value as general? I currently have a formula with [if_not_found] as XLOOKUP value VALUE($A2), but would like to simplify the formula. =IFS( $BA2 = "N", "", TRUE, CHOOSECOLS( XLOOKUP( $A2, 'Data'!$A:$A, 'Data'!$F:$AA, XLOOKUP( VALUE($A2), 'Data'!$A:$A, 'Data'!$F:$AA, "" ) ), 1, 3, 4, 5, 6, 7, 8, 12, 14, 16, 22 ) ) Can I use TEXT formula to change lookup value to General format? I saw another post that suggested the following but returns #VALUE! for numbers formatted as text : =IFS( $BA2 = "N", "", TRUE, CHOOSECOLS( XLOOKUP( TEXT($A2,"General"), 'Data'!$A:$A, 'Data'!$F:$AA, "" ) ), 1, 3, 4, 5, 6, 7, 8, 12, 14, 16, 22 ) ) How can I fix this?
Freeze Panes Question
Hello Excel Experts, I have a problem that I'm facing that maybe you all might be able to solve. I'm trying to freeze my top and side navigation bar in place in Excel. Technically I got the top bar to work, it stays in place when I scroll vertically and technically side bar is also frozen in place but only when scrolling horizontally. Anything below the top navigation bar when scrolling vertically moves. Is there a way to freeze both the top and side columns in place so my navigation buttons are always available to use without using VBA? I have tried the split window option, it works but there's the duplicate view of what was split which if there was a way to hide/lock that duplicate image behind the stationary split view. I also tried combining split view window with the Freeze pane option but that didn't really work I do have a video of what I am talking about with the freeze pane issue option that I'm having which I have attached, along with the file as well Thank you, and I look forward to the help!!!!!
Rounding 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 format dates
Hi, Is it possible to apply a conditional format to a cell. If column I states Yes then highlight red if the date is 5 workings days old and over If column I states No the highlight red if the date is 10 working days old and over If column I states NA or is blank then to not highlight
