Forum Widgets
Latest Discussions
Possible to use one formula in multiple cells?
I have a workbook developed where the exact same formula is used in over 300 cells. I made the formula so that it acts 'by reference' (a lot of use of the INDIRECT() function) such that the formula doesn't need to change based on what cell is executing it. It is a fairly complicated formula that had to be copied and pasted over 300 times to deploy it. The cells are, for all intents and purposes, randomly located within sheets and across multiple sheets, so deploying an update to the formula is very time consuming. My question: is there a way that those 300+ cells can just reference one location to get the formula such that I only have to update the formula once if I need to make changes? Much appreciate any ideas!
Excel shows value in cell, but VBA finds it empty
I’ve written a macro to compare a list of files and mark duplicates. It fails on the third name in the list, because activecell.value=‘’ (Null) is True, but I can see ‘01 in the cell. Why does VBA find that the cell is empty? How can I change the macro to work round this? Thanks in advance, Steve
Linked Excel to Word - Word not updating data
Good morning, I have linked a Word and Excel file using the paste link option, however, when I change the data in Excel file, it does not update the Word file. Also, I am not linking an array, but I am linking cells from different locations in the Excel file to different locations in a Word doc table. I want all the values to update, rather than having to update individual values. The idea is, when I drop the Excel file in to the same folder as the Word file, it will update all the values in the Word file. p.s. I am using MS 365 at work , so I am assuming that these are the latest versions of Excel and Word. I would appreciate any assistance. Thank you.
Formatting / Inputting Help Needed
Hello! I am trying to put together a spreadsheet detailing media I own (4k, Blu Ray, DVD, etc.). I would like to include the run time but I'm running into an issue with inputting and formatting. I can set the format of the column as hh:mm:ss but I'm forced to hard input the colon between the hh / mm and mm / ss. Is there any way I can format the cells / column where I don't have to use the colon and it will automatically input it. That is, a movie is 1 hour, 23 minutes and 45 seconds, and I want to just type in 012345 instead of having to manually type the colon between the 1 and 2, and between the 3 and 4. Thanks!Full Dark Mode in Excel
Currently you can set Office Theme to Black which acts as a dark mode. In Word, setting this to Black makes the page dark and the text white when it is set to “Automatic”. I was wondering if anyone had an idea if Microsoft is planning to release this same thing for Excel too? Right now Excel when using the dark theme makes everything dark except the cells. Which kind of makes no sense to me. This is where your eyes are most of the time. It needs to be a proper fully dark theme. Is there a way to get a full dark mode without manually setting the background color of the cells dark and the text white? Can a plugin be made to do that while keeping the actual cell background “empty” and the text “Automatic”? Is there already a plugin that does that? Thanks!
Create table using LET based on column values
Hi all Hope you can help. I am trying to create an output table based on another tables column data. Example: Original Data Table: Task Target Group 1 Group 2 Group 3 Group 4 Task 1 10 5 10 Task 2 20 10 Task 3 10 5 15 16 Task 4 50 90 10 20 19 Output Table Desired: Tasks Team Result Task 1 Group 1 5 Task 1 Group 3 10 Task 2 Group 2 10 Task 3 Group 1 5 Task 3 Group 2 15 Task 3 Group 3 16 Task 4 Group 1 90 Task 4 Group 2 10 Task 4 Group 3 20 Task 4 Group 4 19 Any advice where to start please? Thanks
ERRORE #VALORE!
Buongiorno, sto lavorando con più fogli e cartelle excel in sharepoint collegando le varie celle, ma in una mi porta #valore!. Nel particolare: nella cartella 1 foglio 32 nella cella A1 ho inserito il valore 11:00, nella cella B1 ho inserito la formula =(1:31!O4), nella cella C1 ho inserito l'operazione =(A1-B1) restituendomi un valore corretto. Poi decido di copiare il collegamento della cella C1 della cartella nella cartella 2 foglio 1 cella A1 mi porta errore #valore!. Come posso risolvere questo errore? Grazie per l'aiuto! P.S. le celle hanno tutte formati uguali TRANSLATION: ERROR #VALUE! Good morning, I am working with multiple sheets and excel workbooks in SharePoint linking the various cells, but in one of them it shows #VALUE!. Specifically: in workbook 1 sheet 32 in cell A1 I entered the value 11:00, in cell B1 I entered the formula =(1:31!O4), and in cell C1 I performed the operation =(A1-B1) which returns a correct value. Then I decide to copy the link of cell C1 from workbook 1 to workbook 2 sheet 1 cell A1 and it shows error #VALUE!. How can I resolve this error? Thank you for your help! P.S. all cells have the same formats.
How to chart this?
Need help on how to calculate then chart this. I have a number of pairs, which I’m imagining as a flow, but with some loops back, and branches: From To A G G C C D C A G F B E E F F E F D I’d like it to figure out a table/chart (but with arrows) like the attached image. It may have optional paths. Doesn't have to be like a flow chart, if there's another way for excel to analyze it. I don't *think* this is a complex b-tree sort of problem... TY in advance.Count U slots
Dear Experts, I have a case like below:- So, there's a Worksheet "Calc" below where we have Slots from 0~19 two times from Col (C~V) and (X~AQ); In ,Sheet2 we have the Logic on how to count the U slots:- 1D --> 1 symbol DL 2DD --> 2 symbols DL 2DU/2UD --> 1 symbol for UL, 1 symbol for DL 1U --> 1 symbol UL 2UU --> 2 symbols UL 1S (for split) --> Half symbol for UL, Half symbol for DL Can you please provide a formula for Column AS and AT to count the U slots, using above Logic, Attached is the Worksheet.
