Forum Widgets
Latest Discussions
Transpose in arrays of n columns
Hello all and thanks in adhance for your help. I am tryting to find a formula or shortcut that would allow me to transpose arrays of n columns into matrixes of n rows and n columns, to plot the data in a different software. In this example I have two arrays, each is 3x3: The software where I need to plot, asks for three arrays of 2x3 as shown: In reality I'm working with three different softwares, the first one gives me raw data that I compute in Excel, obtaining up to 56 groups as shown in the first picture; however, the third software requests the data as the structure shown in the second picture. Any suggestions are welcome.
COUNT UNIQUE VALUES WHILE FILTERING
Hi, I need some help regarding my file. I have managed to count total unique values in column L which is 4,075, however if I apply filter on the dates that are not blank, it still showing total unique values of the whole column L. (screenshot only, I filtered it by date of welding.) this is the formula I use: =SUM(IF(FREQUENCY(IF(LEN(L10:L12194)>0,MATCH(L10:L12194,L10:L12194,0),""),IF(LEN(L10:L12194)>0,MATCH(L10:L12194,L10:L12194,0),""))>0,1)) Looking for some assistance. Thank you
Name Manager does not list all names it has remembered.
There was a table in my workbook called Category. I deleted the table, then created a set of cascading drop-down tables, which the app named as Table1 thru Table6. I then set out to rename the tables with their column headers. This worked fine except for Table1, which I was unable to rename as Category to replace the deleted table, so I renamed it as Categories. My workbook now has only the names shown in this screen shot: When I try to change the name of the Categories table to Category, the app consistently returns: Note that this set of tables is the only content of the workbook, There are no cells anywhere, and never have been, which reference the Category label. I have been programming since 1970. No compiler or interpreter I have ever worked with has ever exhibited this behavior. If I delete a named variable, the name should immediately be available for reuse. How do I work around this defect?Countif Formula Help
I am tracking employee errors on transactions for my organization and am trying to provide calculate how many times each error has occurred over a 12-month time frame. The error reasons are programmed into the employee tracking logs and I have compiled everyone's log. All of those logs have been compiled into one giant list (about 1300 entries). They went super granular when creating these tracking logs and there are 68 different "Error Reasons" - Below is an example of a handful of them. Previously when I have done this, I have manually input CountIf formulas for each of the error codes, which is doable but very time consuming. Is there a way to get Excel to auto populate the error reasons?
Search for Highlighted Cells
Hello, I am an occasional Excel user working on a special project where I created an Excel spreadsheet whose data consists of a large number of comments. What I am trying to do is find any cell that contains a specific word, highlight that cell, and then create a new worksheet that contains all of those cells with the word in it. The best way I thought of to do this was to conditionally format the spreadsheet containing the data. So now, every cell that has the magic word in it is highlighted yellow. How do I pull only the highlighted cells into a new spreadhsheet? Thanks in advance.
French keyboard accounting issue
My Excel document is refusing to format the cells of a row of numbers in French euros format. Anyone have any suggestions on how to fix this? I have contacted support and just spent an hour on this. It will not accept the commas which French format uses instead of the decimal point. Even when the version of the app is put into the French language. Format cells using French or euros do not work either. The only fix seems to be to use decimal points. But this means my software would be incompatible with the Excel file downloads taken from my French accounting system online... the idea of having to change every comma to a fullstop is frankly depressing!! There's gotta be a better way...
If formula problem
Hi all! I am new to using excel so I appreciate your help in advance :) I created a spreadsheet to track multiple choice answers for a quiz. This is the formula to track if people got the answer right: =IF(F3="a",1,IF(F3="b",0,IF(F3="c",0,IF(F3="d",0,IF(F3="-",0,NA))))) However, someone answered "bd" instead of only selecting one and the formula resulted in an error. How do I correct the formula so that the answer would be "0" in that case? Thank you?
Can we prevent Excel from auto-appending year?
Would appreciate it if someone could help me with this little problem: I have a spreadsheet where I do reconciliation of monthly sales, and I usually key in the dates as dd-yyy. Eg, for a payment received on 15th of January 2025 I'll key in "15-Jan" without the year. I only found out today that my December sales reconciliations have mixed dates: eg, some 9-Dec-2024 and some 9-Dec-2025 I went back to check my December-2023 sales reconciliation file and it does have mixed 2023/2024 dates as well. Other months don't seem to have this problem (I've only checked a few files). I'm guessing that: a) those that I keyed in on or before Dec-2024 will have the year as "2024", and b) those that I keyed in after 1-Jan-2025 got tagged as "2025" - cos I remember working on rows 8/14/21/54 in the above screenshot in January of this year. I suppose keying in the full date (day/month/year) will resolve this problem, but if I don't intend to use this data in calculations is there a way to stop Excel from auto-completing the year to the entry itself? Formatting it to "dd-mmm" looks fine on my end, but when I upload the file somewhere and another user downloads the file, somehow that person ends up seeing the mixed year (which was how I found out about this issue). And that's kinda annoying because the other user flagged it as wrong data entry.
