solve

Hello Guys, maybe my problem is a bit more complex, but i want to solve it with formulas. I just need a true or false as output. At first =Find(range,string) doesnt work, i can just put one value into the searched value. If i try, i get false. Example Table A B 1 auto "auto likes flowers...

=SUMIFS(INDIRECT("'"&$C$3&"'!h2:h365"),INDIRECT("'"&$C$3&"'!c2:c365",G3),INDIRECT("'"&$C$3&"'!d2:d365",A13)) This formula returns a value of '0', instead of 40 When I remove the indirect function, i.e =SUMIFS('2019'!H2:H365,'2019'!C2:C365,"="&G3,'2019'!D2:D365,"="&A11) I get the value 40...

Hi can someone help me to my project It is possible to get the last 3 digit number using command button and textbox1 and display the data into other textbox. I wish someone can solve my problem.

Hello guys i need your help i want to get only 1 record with a multiple duplicates of dates but im always getting all the Training hours of a duplicate dates. How can i solve this can you please give me a sample formula using Sumproduct. Thanks!

Hi, I've started getting this error when trying to edit a query or create a new query in Power Query Editor. It was fine yesterday and is happening on any spreadsheet (ruling out a specific corrupted file). I don't know how to diagnose and solve this. I have saved the details of the error if...

I like to play a simulation baseball game where each batter has a card which attempts to replicate the players actual performance and dice are rolled to determine the player bat outcome. The company that sells the game also sells a spreadsheet and claims the player data from the cards is in...

https://photos.app.goo.gl/JiRjueNTERUmu2ev6 I'm trying to auto populate the area in yellow in the screen shot (see link) with the tasks. Each week a person does a task, the next week they move on to a different task. They never repeat the same task in a 4 week period. Its always a 4 week...

Hello. I'm failing at using Dynamic Arrays to completely solve my problem. A brief description: I have a table of items, and I would like to list each letter of the alphabet along with a count of the number of items that start with that letter. Here is a sample table that I have called...

I am trying to solve for IRR. If I want to achieve an IRR in any year of 9% and I have my cash flows but need to solve for sale equity, what should I use? So if in year 4 of owning a property, I want to sell it to achieve a 9% IRR and I have my original equity number and my cash flows, how do...

I am trying to solve for IRR. If I want to achieve an IRR in any year of 9% and I have my cash flows but need to solve for sale equity, what should I use? So if in year 4 of owning a property, I want to sell it to achieve a 9% IRR and I have my original equity number and my cash flows, how do...

So, I'm new here and I want to keep getting better at excel so I want to help answer questions on the excel help board. However, I have two questions that hopefully some of the regulars can answer. 1. If I respond to one of the "Zero Reply" posts and subsequently remove it from the zero reply...

Hello! Can anyone help me explain what's wrong here and how to solve it? {=SUM(IF(MONTH(named_range)=C3,1))} My expectation is that the code should count occurrence of a specific month of the dates in the green field(named_range). Month 2-12 works fine, but month 1 return the number of rows...

Hi, Is there any way that you can solve the exact value of a cell say E9=21.09 using goal seek. I assigned a button for a macro that solves the value of a E9. The problem is for example I input a value say 5, goal seek will return a value of 0 for E9. Hope i could assign a restrain say...

Hello All, It's been a while since I've posted and was wondering if anyone could solve my problem please? Here is my named range with the dropdown in cell K3 I then have a dependant list in L3 Here is the formula I have for the dependant list Everything is working well. However, I...

Hi I am sure this is very simple but having tried a variety of options from other threads I cannot solve it. I am trying to add a simple =sumif formula to a macro: Range("H35").Select .FormulaR1C1 = "=sumif(H4:H32,<=0)" I have tried without the R1C1 as well but the error 'invalid or...

Hi, How can I offset rows based on other cells value. Let´s say cell value of cell B2 = 2 In cell B10: = Offset(B10, B2, 0) In this case it should be offset with 2 rows based on cell B2 value. I can probably solve it through a function in VBA but how can I solve it without VBA? Thanks

I have the following: B72= 1 C72= 1 D72= 1 E72 = 1 F72= 1 And: B75 = "" C75 = "" D75 = "" E75= 18 F75= "" I need a sum of row 72 but only sum if there is a corresponding value in 75. So here the sum would be 1 since there is only one cell in row 75 with a value. If D75 was 10 then the...

good afternoon, i am struggling to solve my issue & hope some 'code wizard' can solve? My issue is , if cell a2 > 0, then insert todays date. So i need a formula for that and if I use Now() the date will change all applicable cells the following day . I need the original date to stay etc...

Hello all, So this is probably a lot easier to solve than i am making it but i need a formula (or VBA) that will solve for the "Dealer Price" (in blue)...