Search results

@ushaanu In the future, please try to be more descriptive in your thread titles. "Excel formula" can refer to almost an infinite number of things.

@malar11567 As you've been warned on other sites, please remember to include links to your cross-posts. https://www.mrexcel.com/board/threads/i-want-to-distribute-the-values-equally-for-layers.1139009/#post-5515339

Welcome to the forum, Earth. Please create a new thread for your question as opposed to tacking onto the end of someone else's thread. You're more likely to get visibility of your question (since people will see a new thread with 0 responses), as opposed to here on a thread that's several years old.

I'm glad you were able to get your question solved. Please note that in the future, you should post links to any cross-posts you create(d). https://eileenslounge.com/viewtopic.php?f=30&t=34629&start=20

Please follow all forum rules, including remaining civil to one another. It does appear that multiple threads have been created with very similar topics. For now, I'll give benefit of doubt. To OP, I would suggest starting a new thread and clearly asking for help with whatever part you are...

I'm not 100% sure what you mean in condition #2, but try this: =SUMPRODUCT((E5:E23<10000)*ISNUMBER(SEARCH({"Int","Chg"},D5:D23))*(RIGHT(E5:E23,1)<>0)*E5:E23)

Administrative Note: Welcome to the forum. We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here. Note: As you are new I...

@BobBridges Welcome to the forum. In the future, please remember to include links to your cross-post. Most online forums (including ours) have rules about this. https://www.msofficeforums.com/excel-programming/44721-conflict-between-dim-redim-split.html You're new, so just posting this as a...

@pda8 Please start your own thread for a question, rather than appending (hijacking) and existing thread.

Try clearing out the Named Range 'ExpirationDate'. Might have an old one in there that's messing you up.

Cleaned up code: Sure thing. Private Const C_NUM_DAYS_UNTIL_EXPIRATION = 1 / 144 Sub TimeBombWithDefinedName() '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ' TimeBombWithDefinedName ' This procedure uses a defined name to store this workbook's ' expiration...

Per forum rules, pleae remember to include links to cross-posts http://www.vbaexpress.com/forum/showthread.php?66912-I-need-VBA-code

Cross-posted (and solved) https://www.chegg.com/homework-help/questions-and-answers/please-assignment-excel-using-solver-submit-excel-file-thapar-theatre-company-needs-determ-q44621047?trackid=59fb658e0014&strackid=ddf507c21609

Closed this thread due to duplication.

Assuming that you would multiply each percentage against the other (so apples-north gets 100% then formula in B17 =SUMPRODUCT(G$2:G$11,INDEX($B$2:$E$11,,MATCH($A17,$B$1:$E$1,0))) Copy across and down to D20

Change the one line of code from this "=VLOOKUP(A2,'" & sourceSheet.Name & "'!$A$2:$B$" & SourceLastRow & ",2,0)" to this "=IFERROR(VLOOKUP(A2,'" & sourceSheet.Name & "'!$A$2:$B$" & SourceLastRow & ",2,0), 0)"

Please include links to your (many) cross-posts. Simply spamming a request across all forums w/o letting the respective members know is considered rude.

@Mark Carver Please take a moment to review our forum Rules & Guidelines, specifically about cross-posting. Thanks. https://www.excelforum.com/excel-general/1297531-automate-goal-seek.html

Please remember to include links to your cross-posts, as called out in our forum Rules & Guidelines. https://www.excelforum.com/excel-programming-vba-macros/1297529-licensing-spreadsheet-via-vba-external-software.html

Check out this tutorial on how to extract a list based on criteria. https://chandoo.org/wp/formula-forensics-003/

But it's also true when the numbers are different. Consider {2, 3, 3, 4}.

Perhaps something like =COUNTIF(A:A, A1)=COUNT(A:A) which checks if all the numbers in col A are equal to A1.

Like this? Need to tweak data layout a bit.

XL only supports 15 digits of significance. As such, I don't think there's a way to 1)input the numbers you're wanting and 2) have it calculate the result. You're also going to struggle with accuracy, since XL (and most computers) have to store the numbers in binary...

Change this line: Set fCell = .Find(c.Value) to this Set fCell = .Find(what:=c.Value, lookat:=xlWhole) and that will make sure it only does a complete match.