Search results

I'm having trouble understanding your example. It looks like the 2 is the position you want, and is one of the inputs? Is the desired result 100, 0, or something else? I think I'll either need more examples, or for you to describe in more detail what exactly you want the computer to do.

Cross-posted (and solved) here https://www.excelforum.com/excel-formulas-and-functions/1327866-three-letter-combination-into-1-to-10-characters.html#post5397831

To install a macro: 1. Right-click on a sheet tab, and select 'View Code' 2. In the Visual Basic Explorer (VBE) that opens, go to Insert - Module 3. Paste the given code into the white space that appears 4. Close the VBE 5. In your workbook, open the macro menu (Alt+F8) 6. Select desired macro...

Cross-post link: https://www.mrexcel.com/board/threads/vba-to-create-filter-data-and-create-folder-save-as-different-workbook.1142935/

Other thread has now been closed; please continue in this one.

@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/