cell

Hoping you can help me out with something that I think is going to be pretty simple. I'm using a Mac with 365 If I enter the following directly into in an Excel cell it works fine. =XLOOKUP(IFERROR(INDEX($Q$2:$Q$210,MATCH(1,COUNTIF(D2,"*"&$Q$2:$Q$210&"*"),0)),""),$Q$2:$Q$210,$R$2:$R$210,"")...

I am trying to build a Stock Options Trading Journal. To this end, I have a Summary page at Sheet1 position and each trade with all its data on each consecutive worksheet page, named with a code representing the trade identifier. Is there a way to automatically draw data from each specific...

BF1OfferLow21.3031.7041.6052.4060.9070.3080.8090.20Low100.20Low111.80121.40133.00141.00Low151.30161.10Low171.90181.70Low192.00202.10212.30221.70Low231.80Low241.90Low252.50F2:F24F2=IF(B2<=MIN(B3:B$25),"Low","") When there are no value lower than a cell value, assign ("Low"), else (""). The...

For context, I am a power user. Investment banker trained. My spreadsheets are highly detailed oriented, know all the keyboard shortcuts, yada yada yada. I say that so this doesn't get filed in the Newb folder. My excel is acting weird lately. Recently in one of my companies excel pro forma...

dear all, I'm currently stuck with Excel and I hope you guys can help me. I am looking to lock specific rows (in the screenshot: the forecast quantity) D6-O6, D9-O9, D12-O12, D15-O15, etc (until D24-O24) after a specific date has passed. This date will be defined in D3-O6. So the way it...

Using "move and copy" option with excel, I copied one worksheet and saved as another workbook. But the copied file text in cell change the color. But when I double click the cell, the color change to the correct one. I really confuse how to fix this...experts please help. Before double click...

As this is my first message here and I don't see any place to make it, i Want to say Hello word and thanks for the amazing job all you are doing for teaching us. I have a question with a macro that works well, but I can't adapt it to improve what I want. I have a book that the first sheet is...

Hello, Workbook name: Report Sheet with pivot: Summary Sheets with data source: Source1 , Source2 (data in range A1:C14) In the above workbook, I defined the name PivotChange_Source with formula =INDIRECT(Summary!$A$1&"!A1:C14") to change the Pivot source within the Workbook based on A1 input...

Hi, I have recorded a macros Sub WarehouseRecieved() ‘ ‘WarehouseRecieved Macro ‘Booked in at the warehouse ‘ ‘ Keyboard Shortcut: Crtl+w ‘ Range(“Q21”).Select ActiveCell.FormulaR1C1 = “Yes” End Sub BUT!! I want to select a different cell (column b) run the shortcut and yes to appear...

CELLWIDTH returns the cell width of the optionally provided Cell Reference. =LAMBDA([Cell],IF(ISOMITTED(Cell),INDEX(CELL("width"),1),INDEX(CELL("width",Cell),1))) It returns ONLY the cell width, not the Spilled Array CELL("width") now returns. Note that the value returned is the width of the...

Remote* Cell values in a named range "MyNamedRange"** have following structure: "U. HeaderName - KeyWord"*** Filters and HeaderName row is in row 10 Objective - Upon Right Click on a cell in above named range: - Filter in Column U using the "KeyWord" * Remote - as in it is not part of the...

Good day everyone, I want to program a button that can delete a row if it doesn't have anything below it. Here's an example of what I'm talking about. Initial Example: By clicking a button, the result should be like this: It will delete Region C and E because it doesn't have any name below it.

Hi everyone, I have another question for everyone. This one is a bit complicated as several aspects of the code need fixing, and I am having a hard time doing so. If there are any helpful mind out there please have a look at he the problem below. What the VBA code should do: Each time text is...

Hi All, I'm trying to create a summary page that automatically updates with certain values when creating invoices on excel. Is this possible? I want to be able to render different invoices but have a summary sheet which keeps all the data in one. What's the best way to go about this? I want the...

Hi all, Worksheet_SelectionChange event doesn't fire if I change the selection from a cell to an image. Does it only fire if a cell is selected (it seems to be the case, but I thought I'd check)? Option Explicit Private Sub Worksheet_Activate() Application.EnableEvents = True End Sub...

Hello, I have two sheets, first of them has a data table with the income of a list of 14 companies during 2018 and 2019. The other sheet I've a data table with a list of these companies and next to the name an hiperlink. When it's selected, it transports you to the cell located in the row of...

How do I enter sequential numbers based on cell value start with D9 and end with D7 (30 years term) and I would like to calculate in range Q3:V14. If I change D7 value to 10 years, in range Q3:V14 should count only 10 years and stop. See my attached XL2BB file. Thank you so much for your help...

i dont seem to make progress bcs I dont have experience. Maybe you guys can help me out. If a button is checked i want it to display the text in a free cell from A1 to A14. I tried .TypeText „…“ but that does not work. Help is much appreciated

Hi all! I have the following email macro: Now, what I am wondering, is whether it might be possible to ignore certain emails from being targeted on the list that I have designed in my "for i = 2 to 10" code? A nice solution personally for me would be if I could simply just highlight the cell...

I have >100 files, all with the same make-up. I use Sample File to get a 'specific part of the table'. I also need '1 value' of this table from a specific cell, BUT this value is filtered out in the steps to get the 'specific part of the table'. I could Add (the '1 value') as New Query before I...