How to delete multiple cells based off the value of a specific cell.
I have an excel file with multiple sheets. I was wondering if there was a way to complete this task. When I delete the value in the column of "Hose"(A), I would like it to automatically delete everything in C9:K9. Looking at the image uploaded, when I delete "811HT-24", it would then delete RCC,x,7458,1x24,2x24,3x32,1x48 if it worked like I'm hoping. In the B column I'm using VLOOKUP tied to an index. All of the sheets are identical as well. Any help would be appreciated.
Typing ö using US Int keyboard's standard right Alt+P wrongly deletes all contents of a cell
Lately when I want to type ö (German letter o umlaut corresponding to Alt+0246) with US Int keyboard, which is located at "right Alt+P" (or also I have it mapped to "right Alt+O") deletes all the content of the cell that was written there before typing the letter. I.e., if I'm typing "Hellö" after adding "ö" it will immediatly transform to just "ö" in the cell. It is not the case with any other "Right Alt+ letter" combination, just this one and appeared just very recently. Could it be some kind of a bug in Excel or the problem lies somewhere else? My Excel version is:Microsoft® Excel® for Microsoft 365 MSO (Version 2211 Build 16.0.15831.20098) 64-bit Thanks in advance!
Excel Formula
Good day to all! Please help me on my project. I want to create an excel formula that comes out on this situation below: Column A & B is a given data. Then Column E is the value/text which need to find on column B base on the headers. Then Column F is the column that I wanted to have a formula that indicates match or not match base on Column E situation. Please the files. Thank you!
Help me with Formulas pls!
Hi everyone, I have a main sheet named "DAILY INWARD OUTWARD" that contains transactions for over 50 parties. Each party does multiple transactions, and I need to manage their stocks. Currently, I manually create separate sheets for each party and record their transactions, which is time-consuming. See this is my master sheet and I make stocks like this That month Jodhka made 4 transactions, so by searching in master sheet all over made manually my diff party list. likewise i have to maintain 100+ party details, so anyone can help me reagarding this? I would like to automate this process using VLOOKUP and VBA macros or anything. Specifically, I need help with: Using VLOOKUP to fetch transactions from the main sheet to individual party sheets. Writing a VBA macro to create separate sheets for each party and copy their transactions from the main sheet. Any guidance or examples on how to achieve this would be greatly appreciated. Thank you! hereby attaching excel file too https://filetransfer.io/data-package/beXdVs3F#link
Missing CONCATENATE
Why does Excel no longer have CONCATENATE function listed under text functions in the Insert Function dialogue box? The CONCAT function is there but not the CONCATENATE. Note, you still have the ability to use the concatenate function but not choose it from the Insert Function dialogue box. I have tried the CONCAT function but noticed it does not work exactly like the CONCATENATE which I've used for years and still prefer in most cases.Issue with the s/n for 2/29/1900 when using EOM function
When using the EOM function for February 1900, Excel is using a serial number for 2/29/1900 of 59 not 60. I am aware the 1900 was not a leap year, but I understand that for compatibility Microsoft coded 2/29/1900 as a legitimate date in Excel for compatiblity (I believe) with Lotus 123. This creates a problem in a annual calendare I recently created that has a potential years from 1900 - 9999. But because of the issue with 2/29/1900 Excel will not properly apply the conditional formatting for the year 1900. Below is an example of calendar when the year 1900 is chosen and one when any subsequent year is chosen.Automating Party Transactions in Excel Using VLOOKUP and VBA Macros or anything
Hi everyone, I have a main sheet named "DAILY INWARD OUTWARD" that contains transactions for over 50 parties. Each party does multiple transactions, and I need to manage their stocks. Currently, I manually create separate sheets for each party and record their transactions, which is time-consuming. See this is my master sheet and I make stocks like this That month Jodhka made 4 transactions, so by searching in master sheet all over made manually my diff party list. likewise i have to maintain 100+ party details, so anyone can help me reagarding this? I would like to automate this process using VLOOKUP and VBA macros or anything. Specifically, I need help with: Using VLOOKUP to fetch transactions from the main sheet to individual party sheets. Writing a VBA macro to create separate sheets for each party and copy their transactions from the main sheet. Any guidance or examples on how to achieve this would be greatly appreciated. Thank you!
Dynamic Arrays - Changing a row by row Spilled Array to a block - Replacing Sumifs?
I have already had some help putting this together as a stop gap solution but need a more permanent one. File attached explains most. But I'm building a Depreciation Base which is how most Accounting firms model depr for project finance by adding all capital purchases to a depreciation base which is an accumulation of all purchases for that item for the duration of it's useful life. ie Buy 100 in Jan 2022 for life of 3 years. Add another 200 in Jan 2023 and another 250 in Jan 2024. In Jan 2022 the Depr base will be zero (There is usually a 1 period offset and this model will be in months not years but using years for the example to keep the column count short. In Jan 2023 the Depr Base will be the 100 from Jan 22 making 100 In Jan 2024 it will be the sum of the 100 from 2022 plus the 200 from 2023 making 300 In Jan 2025 it will be the sum of all three making 550 In Jan 2026 (assuming no more purchases it will then be the 200 from 2023 and the 250 from 2024 making 450. The initial 100 from 2022 will have expired. The attached file gives a clearer picture. I have a solution to do this row by row but need it in a block - see the file I can't figure out how to achieve this and would much appreciate some Genius help!!I have formulas that put things into cells
w l t in cells b23:b40 I need new formula b23 =IFERROR(IF(AND(C23="",H23=""),"",IF(C23=H23,"T",IF(C23>H23,"W","L"))),"") drop down to b40 It shows T. I don't want a T until the scores are the same. C23:C40 I want score be empty see 0. if put 0 -0 than put T Thanks You
