Forum Widgets
Latest Discussions
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
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!
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.Data info in separate date columns
I need to put data information in separate date columns in the same excel project. Let me give you an example. The project have 4 quarters lasting 3 months each. I need to put data information on each quarter column. People who use our service and we put information in quarterly report column. See this example below. Name. - age - gender - race Quarter 1 (Jan to March). Quarter 2 (April to June) Quarter 3 (July to Sept), Quarter. 4 (Oct to Dec) I need to separate the group of data into each quarter column so it won't repeat in other quarters using the formula on excel. I have used COUNTIF to calculate the group for each quarter column. I tried DATE but I got error, "#NAME?"
Summarize multiple columns of varying row lengths into one column.
I am copying old data into into Column B and add my own findings to Columns D and G. I'm looking to summarize the data as depicted in columns P&Q. What I've got making the M&N columns is M: =IF(NOT(ISBLANK(A4)),A4,"") N: =IF(NOT(ISBLANK(B4)),B4, IF(NOT(ISBLANK(D4)),D4, IF(NOT(ISBLANK(G4)),G4,""))) I don't know how to account for a variable number of rows between sample ID for column and multiple items from the columns B,D,G printing on different rows in the desired data set. Thanks in advance.Toggling autosave on saves despite saving has been disabled in VBA
I have an Excel spreadsheet that is used to calculate certain data and give a printable report. For the report patient information must be given. That information must not be saved. To accomplish that I've put following code into ThisWorkbook, and it works mostly as needed: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cancel = True 'Cancels any request to save the file End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.ThisWorkbook.Saved = True 'Tells Excel that the file has already been saved (this prevents Excel from requesting that you save the file when you close it) End Sub And autosave has been disabled with code: Private Sub Workbook_Open() If Val(Application.Version) > 15 Then If ActiveWorkbook.AutoSaveOn Then ActiveWorkbook.AutoSaveOn = False End If Yet, when autosave toggle is clicked on, Excel saves the file. If the autosave is left turned on, after few seconds it displays the message, and doesn't allow saving any more, but at the moment the autosave is turned on, the file is saved. I've found a workaround. If I mark the file as final version, it can't be saved, but then it also needs additional click of the "Edit anyway" button before any data can be inserted. The file is available to other users via SharePoint, I can't manage file permissions. Is there any other way of dealing with this?Filter formula for looking up data in a table
Hi, I,m looking for a formula that can lookup and return results when I select the name and return the vehicles at the top eg - Andy Scooter Bicycle Car Bus Thanks for any help Scooter Bicycle Motorbike Car Bus Lorry HGV Andy x x x x Brian x x x x Carl x x x x x Dave x x x
