Recent Discussions
Help with formula
Hello! If I'm trying create a formula that pulls data from one sheet into another. I want it to pull in data in column E if column B has a january date AND column C has the word discover in it, into another tab within the same workbook. The formula below works perfect but the only problem is it has to be only the word "discover" (yellow cells) in the cell, if it says "discover - food" (green cells) it doesn't pull. Is there a way to have the formula pull the data if the word "discover" shows in column C but with other words like in the green cells? My current formula that kinda works: =INDEX('My ✓ing'!E:E,MATCH(1,(MONTH('My ✓ing'!B:B)=1)*('My ✓ing'!C:C="Discover"),0)) Pulling from this sheet below Into this sheet in the same workbook. The yellow ones work because it just has discover, the green is not cause it has Discover - food. Is there a way to get it to search for the word discover and not necessarily match? Thank you for any help!
Error installing Apps 365, command not supported.
I was performing an Online Repair for a user. It did the uninstall fine, but then threw this error. I tried to reinstall, same error. Used the MS Cleanup tool, ran SFC, cleared temp files, cache... Internet connection is stable. Disabled security software (Zscaler). I'm out of ideas. I'm hoping someone has seen this before. Thanks for any help!
Extract data using text within set of data
Hi i have a set of data with keywords containing SLS1,SLS2,SLS3....SLS10, ULS1,ULS2....ULS10. i wish to segregate this into separate set of SLS and ULS using certain condition like max axial. For ex. cell P8 should return the max axial value out of load case under column 'C' wherever the load has substring "SLS" in it.
Formula help - not sure where to start
I have this data: I want to create a sort of calculator where based on the rate and production multiplier, the result is the commission structure value. The problem is, the calculation I am using in the calculator to get the production multiplier may not return an exact value that matches the above data. It could return 1.32. I would need a formula that looks for the closest value to 1.32 and also has a rate of .14 and return the commission structure result. In this example, I would want the commission value of 0.08 returned. Is that possible?
Different columns format within an existing column layout
Hi, As the picture show, I need to start with two columns text layout in a page and in the empty area on the 2nd column, make the remaining into 4 columns for text and small pictures. Is there a way to do that using columns layout? I tried to insert section break but section break will split and shorten my initial columnal text and leave the entire bottom area empty. I only need the right bottom for new columns. Is inserting a table the only way to achieve this? I prefer columns so that long text body will flow into the next column in the page. I really wanted to avoid using linked text boxes because the user of the template tends to mess them up.Excel (on Mac) Macro Highlight to the Top of a Column
Column F in the below table includes a blank cell. In a macro, I want to highlight cells F2 to F10. Since I could have any number of rows of data, I wrote the macro to get me to the last row of data, then highlight my way up using: Range(Selection, Selection.End(xlUp)).Select But since I could have any number of blanks in Column F, I had to repeat that line 12 times to be sure my highlighted range would always go to the top of the column. Is there a way to anchor the highlighting at the last row of data (as I have done), but then make E2 the "top" of my highlighted range?Payback Period
In my file, how should I adjust my payback period formula so it "always correct", in that it always uses the correct formula as in the year it is not negative for the cumulative cash flow row? Is there anything else incorrect in my other financial ratios? I need a sanity check on NPV, IRR, ROI as well. The current formula for Payback is: INT(C3+ABS(C36/D34))&" Years and "&ROUND(C3+ABS(C36/D34)*12;0)&" Months" NPV: SUMPRODUCT(C34:G34;C39:G39)+B34 IRR: IFERROR(IRR(B34:G34);"N/A") ROI: IFERROR((SUM(B23:G23)+SUM(B32:G32))/-SUM(B32:G32);"N/A") Many thanks in advance!
Recent Blogs
- Your product will still work, but when Microsoft says a product has reached "end of support", it means the product will no longer receive: Security updates Non-security updates Bug fixes Ne...Sep 04, 2025
- Customers in Austria now have new options for managing the location of their Microsoft 365 data.Sep 02, 2025
