Anybody up for this one, the OP might be getting a tad impatient, I think it's now urgent! ...
bill of material (multi)
Anybody up for this one, the OP might be getting a tad impatient, I think it's now urgent! ...
bill of material (multi)
Can't come up with a formula that gives the required value for this one.
http://www.excelforum.com/excel-gene...-database.html
![]()
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Anyone for VBA solution here?
http://www.excelforum.com/excel-prog...mat-macro.html
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Looks like I've shattered someone's illusions.
Can anyone throw a positive light here:
http://www.excelforum.com/excel-gene...y-desktop.html
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
This old thread the OP is back, and short of just creating four separate formulas for each pair of cells, looking for a creative elegant solution like DDL's original suggestion but that actually handles all the variations.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This OP has a unique data reformatting project?
I am hoping someone can help out with this post:
http://www.excelforum.com/excel-prog...cell-loop.html
I have gone about as far as I can (which isn't all THAT far). My original code kind of/sort of did what he asked, but his follow up posts added more requirements that I am not knowledgeable enough to answer.
- Moo
Having real difficulty in understanding what this OP is trying to do. Perhaps you will understand better.
http://www.excelforum.com/excel-gene...-one-cell.html
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Can someone help with a formula solution here ? http://www.excelforum.com/excel-form...ssignment.html
I jumped into the thread not seeing that the OP was looking for a formula solution.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
anyone gopt any ideas for this OP?
http://www.excelforum.com/excel-form...html?p=3055687
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Good chance (very good chance) there is an easier way to do this, but it seems I have a decent working solution outside of "B-InterfaceUnit" being counted twice.
I have not posted the workbook yet to the thread as it's not complete, but would anybody be so kind as to give me a helping hand?
Count should be 74 and because of the dup I'm getting 77
Attached is my working model.
HTH
Regards, Jeff
Any thought on where to go with this?
http://www.excelforum.com/excel-gene...ged-cells.html
Anybody have some thoughts on this cut, copy, and paste thread?
http://www.excelforum.com/excel-prog...worksheet.html
maybe some=one here can figure this 1 out, i sure cant
http://www.excelforum.com/excel-prog...html?p=3060333
http://www.excelforum.com/excel-prog...-inserted.html
Hi All. I am S.T.U.C.K. on this. Please review and advise if you have any suggestions. I think my last post on the thread explains where I am at.
Hi John,
I think you missed the intention of this thread. This thread is not for an OP to personally place a message asking for help; rather, it is designed for a member who is helping an OP to ask for further assistance when they get stuck.
Can anybody come up with a reasonable explanation for why the advanced filter will not work?
Thought I found a solution, but it keeps bugging on...
![]()
Please Login or Register to view this content.
I just discovered this thread. I think I'll come here first from now on. Starting tomorrow.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Or perhaps start here at the current thread:
http://www.excelforum.com/the-water-...3-onwards.html
I think M. Beaucaire has given me good direction - It would be nice if every thread initiator would edit the thread to say that it's been solved before "Ragtime Cowboy Joe" tries to ride to the rescue - tres frustrating![]()
Yeah, that's smart. With that link in post #819 (whew!), we'll retire this thread now.
Good night to 2012...
Those interested in Cavalry calls should consider subscribing to the new thread located here:
http://www.excelforum.com/the-water-...5-onwards.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks