excel
44337 TopicsHow to create a Date-Time Temperature Graph
Hi there, I was wondering if Excel is able to create a similar Date Time vs Temperature graph as shown, the green coded one? (the data was extracted from an app) I want to be able to show the Date AND Time on my Excel chart I have the raw number data but is unable to convert it into a graph similar to the one shown above, for reference the format of my raw data looks like this (below), but my raw data have three thousands results. Thank you in advance to anyone who can help me! - Non10Views0likes1CommentUnwanted automatic change of text number format to scientific
I have a simple spreadsheet in which I was trying to list "codes" for keeping track of data for a game I'm working on. (Table top dice game) I find that the codes 01P2 or 01G2 can be found and replaced with 02 or 03, etc. However, my code 01E2 etc. changes automatically to scientific format. Apparently something about the "E" triggers some sort of auto response. I looked around in options but found nothing that seems to apply to this. I tried chat but the techie wanted to take over the computer, which sounded to me like overkill. He transferred me to second techie who dumped me out of the chat. First time ever I gave feedback of one star. Anybody have a simple solution?59KViews1like15CommentsUpdate Excel formulas between a path in local folder and owncloud in another computer
I have a lot of Excel archives with lots of formulas which reference other Excel files, all in the path H:\Fold\Data\physics on a computer, and at the same time, on another computer, I have an owncloud folder C:\Users\fulanito\ownCloud\Shared\Data\physics. How could I change the paths in formulas to be able to update the data when I open them in the owncloud folder or in the original folder? They share part of the same route: \Data\physics The local folder on one computer (H:\Fold\Data\physics) is synchronized with owncloud, I share the folder Data. Mounted folder in owncloud in another computer: C:\Users\fulanito\ownCloud\Shared\Data\physics I tried to use relative paths but that works only if all archives are in the same folder. In my case for the owncloud path, for example one archive, data_2025.xlsx is in C:\Users\fulanito\ownCloud\Shared\Data\physics\2025 another, data_2024.xlsx, is in C:\Users\fulanito\ownCloud\Shared\Data\physics\2024 the Excel that use formulas with references to these two archives is in C:\Users\fulanito\ownCloud\Shared\Data\physics\summary. So if I want to update the summary archive daily_summary on the computer with owncloud, all the archives have to be in the same subfolder \summary\ Examples of formulas I use in the summary sheet to reference my files in H, in Excel daily_summary.xlsx are ='H:\Fold\Data\physics\2025\[data_2025.xlsx]Horario'!AV1419 and in another cell next to this is: ='H:\Fold\Data\physics\2025\[data_2024.xlsx]Horario'!AV1419 So if a make a change in data_2025 in that cell and I open on the computer with owncloud, it can't update because it references the local computer H:. I prefer not to use macros.Solved46Views0likes3CommentsExcel: Count cells with specific value + colour
Hi there, I would like to be able to count the number of cells that contain a specific value and are shaded a specific colour. This is for a rota spreadsheet that will be tallying the total number of shifts which have been agreed. The cells that contain "Yes" as a value from a drop down list and are shaded green, should be counted as part of the quarterly total. I'm assuming that a VBA custom function would be needed for this. I've tried a few but cannot figure out a way to get this to work with both a specific value and colour. I would be very grateful for anyone that is able crack this challenge. In the example screenshots, it is the cells shaded in green that would need to be counted and the totals appear in column GJ. Best regards, Daniel156Views0likes5CommentsHow to make excel add or remove rows to fit data and prevent spill error?
Hello! My question is: When using the =FILTER formula to copy cell data from one sheet to another, how can I make excel add or remove rows as needed to prevent a spill error? I am using the =FILTER formula to copy cell data from one sheet to another if a checkbox is checked. My formula uses the cells containing the checkbox (column A) as the reference for columns B, C, D, etc. to the right. I did this by selecting the cell that has the formula on the destination sheet, highlighting this cell and those to the right I wanted to transfer, and then control + r. My formula is: =FILTER('Source Sheet'!B5:B13,'Source Sheet'!$A5:$A13=TRUE) (If there is a way to copy an entire row from the source sheet instead of having to control+r to apply the original formula across select cells please also let me know, thank you!). However, I want the sheet to be able to automatically add rows to fit the data if the selected number of rows is greater than what I have left available on the sheet. Currently, if I leave 3 rows for data to fill and I select three checkboxes, this will fill the space with no problem. However, if I select 4+, I get a spill error (as there are not enough empty rows to put the data). Is there any easy way to have excel add rows as needed? Similarly, is there a way for excel to remove rows as needed? I am going to use this sheet to detail all medications being taken by family members (with medication name, concentration, dose, time to take each in their own column as column B, column C, column D, column E). The names will be listed in column A with ~3 rows below each name which will fill when the checkbox on the source sheet is clicked. I want to ideally fit this on one page when printing without major "fit to page" problems that come up during printing. The layout of the sheet will ideally look like this: The goal for the 'destination sheet' is to pull only the selected data I want to use from my master list on the 'source' sheet.' I want to avoid having a big empty space under each family member where they don't take many medications, and to also not have to manually add rows for family members that take a greater number of medications. Please let me know and thank you!71Views0likes3Comments