Call in the cavalry -- need help solving this thread-prior to 2013

[Mordred]

Alrighty all you guru's, please have a look at this thread. The VLookup being use is acting strange and I don't know enough about VLookup to know why. Thanks!

[Mordred]

Hi all, I've been trying to understand the user from here but am more confused by his answers to my questions and I was hoping that one of you wise gurus might understand his/her criteria.

Thanks!

[Mordred]

And another! This person wants to know about exact searches using Find. I don't know the answer for him/her. Please help here!

[martindwilson]

http://www.excelforum.com/excel-gene...and-sumif.html
frequency/if cant get my head around this help please anyone

[ConneXionLost]

No worries Martin, I got you.

[martindwilson]

nice one good solution.

[ChemistB]

Charting issue
I solved the OP's initial range issue but even when I delete columns with blanks in them, I cannot get the OP's x axis to chart from a value different from zero. Thanks in advance.

http://www.excelforum.com/excel-gene...in-charts.html

[teylyn]

ChemistB, I added a suggestion.

[ChemistB]

Thanks Teylyn!

[Mordred]

I have tried to help this person out at this link but for some reason, the workbook before save event is asking to save twice and I don't understand why. Please help.

[TMS]

Please could someone have a look at this thread: Clear Cell After Messagebox

I can't quite get my head around what is wanted/needed.

Thanks, TMS

[ChemistB]

This one will probably require VBA. Otherwise, there's just a boatload of INDIRECTS that's going to slow their system down to a crawl.

http://www.excelforum.com/excel-gene...her-table.html

[Mordred]

If someone can help this fellar out I would appreciate it. His/her requirements are confusing me and I think he/she is having a hard time (or I am dull today which is always a possibility) explaining the criteria. At any rate, here is The Link

[davegugg]

I'd be very interested to see a worksheet function solution to this thread. At first I though it was a simple index/match solution, but then I found out Match isn't case sensitive. I can figure out how to test if the correct match is found, but I can't figure out how to find the other solution if the correct match is not found.

Obviously a VBA solution would be fairly simple, but can it be done with a worksheet function?

Edit: Looks like NBVC got it just as I wrote this.

[Marcol]

I need a fresh mind with this one, I just can't figure out what the OP wants.
Conditional formatting with array formula?

[jeffreybrown]

Could I get a thought on this thread

The OP needs to ignore blanks when concatenating all cells between A1:A300 into cell A301

My suggestion is to remove all blanks and then return the results into B1. Not sure if this will meet the OPs needs.

[daddylonglegs]

some VBA help here?

[ChemistB]

Need a VBA solution because Conditional Formatting and Number formatting not working too well.

http://www.excelforum.com/excel-gene...-question.html

[JBeaucaire]

Here's one for you football draft fans... HELP NEEDED HERE.

[abousetta]

Does anyone know how to create a userform that mimics the built-in Excel Find Dialog Box, but will allow the user to use Ctrl+A. If so, here is someone in need of help.

Thanks.

abousetta

[jeffreybrown]

Need some VBA help here...

The OP can use the UDF to concatenate the values which are seperated by a ;

Now he wants the colors to transfer also...

http://www.excelforum.com/excel-gene...ml#post2588035

Please Login or Register  to view this content.

[Mordred]

http://www.excelforum.com/excel-prog...ml#post2588052I almost feel like I am cutting in line now (because Jeff just posted not long ago). Can someone look at this thread? I looked at the uploaded workbook and I have decided that beer drinking this weekend is what my body and mind need so I won't be looking at that thread until at least Sunday. At anyrate, I'm sure it would be appreciated.

[jeffreybrown]

Anybody have a thought here...

http://www.excelforum.com/excel-gene...functions.html

[NBVC]

Here is one that needs some VBA assistance to append rows from one sheet based on a condition, to another sheet that already has some hard-coded rows entered...

http://www.excelforum.com/excel-new-...-copy-row.html

[jeffreybrown]

Not sure on this one here...

http://www.excelforum.com/excel-gene...e-results.html

[NBVC]

I offered a Formula solution here, but looks like the OP desires a macro instead... if anyone is interested.

[zbor]

Can you write UDF for this... I would also like to have it

http://www.excelforum.com/excel-2007...x-y-graph.html

[JBeaucaire]

I'm not a charting man, so any extra eyes on this would help the OP:

http://www.excelforum.com/excel-prog...a-complex.html

[jeffreybrown]

Can't wrap my brain around how to achieve this result in a formula...

http://www.excelforum.com/excel-2007...-criteria.html

[ChemistB]

I'm just not sure what this guy is asking for.

http://www.excelforum.com/excel-gene...ata-table.html

[Andrew-R]

This one isn't really a call in the cavalry, but last week we had a guy asking for a single formula to return the highest number of consecutive rows in a column containing the value 2. It's not worth me posting a link to his post, because he edited the original to delete the question and instead say he'd found the answer.

The thing is it's been bugging me ever since.

The example he gave only had 20 rows in, and for 20 rows the formula {=MATCH(TRUE,INDEX(ISERROR(SEARCH(REPT("1",{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),SUM(IF(A1:A20=B1,10^ROW(A1:A20))))),0),0)-1} works just fine.

But it's bugging me because I know that formula isn't scalable. I've scratched my head trying to think of a better solution with a single formula (obviously it's trivial with either a helper column or some VBA), but I can't think of one.

Can any of the cavalry out there put me out of my misery?

[NBVC]

Not too sure what you mean by scalable here, but something like this perhaps, is an alternative?

=MAX(FREQUENCY(IF(A1:A20=2,ROW(A1:A20)),IF(A1:A20<>2,ROW(A1:A20))))

CSE confirmed.

[Andrew-R]

My formula works by creating, effectively, an x digit long binary number, where x is the number of rows - so it wouldn't work for, say, a column with 1,000 rows in, because the number would exceed the largest number Excel will handle.

Your formula works brilliantly, though - thanks. I've never used FREQUENCY before, so now I'm going to have to go and read up on it.

[Blake 7]

Could someone pls check to see if they could offer anything else to this. Cheers

http://www.excelforum.com/excel-gene...le-lookup.html

[MarvinP]

My answer isn't good enough for
http://www.excelforum.com/excel-prog...ml#post2598427
Anyone interested in combining two sheets into one and showing the differences?
BUT - it has be be in his special formatted way.

Thanks in advance - I'm done with it.

[ChemistB]

I think this one would require a UDF that extracts numbers within parentheses and sums them. I'd like to see this result too.

http://www.excelforum.com/excel-gene...ains-text.html

[ChemistB]

Thanks for all the help with that last post. Lots of good input.

I need help simplifying this one.

http://www.excelforum.com/excel-gene...occurence.html
Thanks in advance.

[Domski]

Anyone able to pick this up?

http://www.excelforum.com/excel-gene...ction-2-a.html

I'm up to my eyeballs at work at the moment and going away for the weekend so not going to be able to help him any further.

Dom

[ConneXionLost]

The goalpost shifted with this one:

http://www.excelforum.com/excel-gene...-criteria.html

Any takers?

[ChemistB]

Not sure how to solve this one

http://www.excelforum.com/excel-gene...e-vlookup.html

792592-generate-a-form-if-another-cell-has-a-specific-value-but-otherwise-use-vlookup

[zbor]

Macro needed:

http://www.excelforum.com/excel-gene...-criteria.html

[arlu1201]

I would suggest that maybe we have a different icon for these kind of posts or maybe a different color background. Also, these should be available in a different window so that people can have a look and reply.

[Domski]

Changes to the forum that the people who use it actually want! Oh look, that stone's bleeding...

Dom

[Andrew-R]

Can anybody help me out with this one, please?

It seems that the OP wants to return multiple values to the same cell. I could do it in VBA, but I was wondering if there was a formula solution.

[daddylonglegs]

Given a large range and unlimited number of matches that would be virtually impossible to do with a formula, Andrew - it's possible to have one value returned per cell, otherwise VBA

[Andrew-R]

Yeah, that's what I thought, but I thought I'd ask in case snb wanted to slap me for not knowing how to use TRANSPOSE properly

[alansidman]

Can't figure this one out. I applied the round function to all items in the table and still comes up with differences in Column G. What's the reason for this occurring if the Round function to two decimal places is used.

http://www.excelforum.com/excel-work...-rounding.html

Alan

[Domski]

Anyone fancy picking this one up:

http://www.excelforum.com/excel-prog...ml#post2605439

Apparently it's not working.

Dom

[Colin Legg]

I've pointed out one error. Scanning down the code I think there will be more to follow...

[TMS]

@Dom/Colin

I might be missing something here, but this is a function not a subroutine (macro).

Could that have a bearing.

As a function, how is it being called?


Regards

[Domski]

Sorry but I've washed my hands of that one. Lost cause.

[TMS]

@Dom: some people would try the patience of a saint ;-)

[zbor]

I think VBA needed: http://www.excelforum.com/excel-prog...-together.html

[ConneXionLost]

Saint Domski

[Mordred]

Hi all, the following thread's formula is beyond my understanding regarding how to put it into code.

[TMS]

Could someone pick up on this, please:

Automation error

The possibility has been posed that the problem might relate to a proxy server. This is beyond my level of expertise.

Thanks

[alansidman]

OP at this thread is looking for an alternative that is Excel based only. Are you able to help as I could only provide an Access solution.

http://www.excelforum.com/excel-gene...t-of-data.html

Alan

[Marcol]

Can anyone see what's required here?
Common finder
I'm totally mucking fuddled ...

[Andrew-R]

Personally I think you did well to get two formula in there, Marcol. I've read and re-read that thread and I can't make head nor tail of what he wants.

[Marcol]

Thanks Andrew, I thought I needed more beer so I rectified that situation, but still couldn't see OPs' logic! ...
The last post attachment has now had 11 views and only one more reply which hasn't been answered.
Guess I'll give it up as a lost cause. (Not the beer though.)

Slainte
Alistair

[TMS]

Anyone got any thoughts on this?

Reset object number


I've very quickly run out of ideas.

Regards

[tigeravatar]

Guys,

Can somebody take a look at this thread please? I can get formulas to work, but cell L14 isn't entirely accurate and I'm not sure how to go about making it accurate. Hopefully one of you can trump what I've done to get this actually solved.

[JBeaucaire]

This OP at this thread is apparently needing of a mix of form controls on the sheet and the sheet itself... I tried to show what I believe is more efficient and easier to maintain method with no form objects, no dice. (see post #5)

Any support on my suggestions or tips on what the OP wants instead, I don't have the heart to acquiesce. Thanks.

[alansidman]

http://www.excelforum.com/excel-prog...tch-timer.html

This one is beyond me. A challenge for those looking for one.

Alan

[Andrew-R]

http://www.excelforum.com/excel-gene...-the-cell.html

Anybody know anything about importing into Open Office?

[jeffreybrown]

It appears the OP here would like to filter as they type in a drop down list to narrow the search.

They have it setup right now with data validation which will not work in this method, but seems I have seen before where this could be done with a combobox but just not sure.

Any thoughts?

[inayat]

Hi All,

I had posted this thread andit has not been solved yet. So I thought I may post it here so that you can have a look at it.

http://www.excelforum.com/excel-gene...criterias.html

Mods: I don't think that this is against the rules. However, if you feel that I should not have posted here, please feel free to delete the post.

Cheers-
Inayat

[teylyn]

inayat, this thread is not intended to bump your own questions, but rather for finding assistance when somebody gets stuck answering a thread.

[zbor]

bebo021999 and me solved it now so we can close one eye

[inayat]

Hi Teylyn...

Will keep this in mind in future. I had also written in my post that if mods believe that I should not have posted here, then they can delete my post. The only reason I posted here was that I did not get any response for quite some time... And I guess the reason for this thread is that to get the solution to OP.

However, point taken and will refrain from posting my own question here in the future.

Cheers-
Inayat

[JBeaucaire]

I have no ideas on this one at all.

[TMS]

Can anyone throw any ideas at this, please:

Combining two formulas

I've had a tinker with it but I'm out of ideas ... and the combined formula is hellish long.

Thanks, TMS

[Marcol]

I'm way out of my depth with the formula here.
Min and Max value if a line is compared against multiple criteria

Maybe the OP will be happy with Rylos' VBa, but a similar thread was solved by DLL with a formula.

Cheers,
Alistair.

[Marcol]

Thanks DLL, I tried and failed! ...
I could see what had to be done with MMULT() just couldn't apply it.
Your reply in the thread really helps.
And hey I kind of hoped it would take you more than 10 mins to see the problem and solve it!

[daddylonglegs]

No problem, took me at least 15 minutes though......

FWIW MMULT is a tricky function to get to know, but sometimes worth it.

[NBVC]

I think Domenic is arguably the king of MMULT (especially when combining with TRANSPOSE). You should see some of the magic he can perform with that combo I still have trouble trying to piece those together from his solutions.

[jeffreybrown]

I believe this can be done in an array formula, but just can't seem to grasp it.

Any thoughts?

[daddylonglegs]

I think Domenic is arguably the king of MMULT.....

Not even arguably.....definitely

[Marcol]

The more I see of the "obscure" native functions in Excel the more I wonder why some members dedicated to VBa one liners bother.

Why use 17 lines of gobble-de-gook and press a few buttons when it can be done dynamically with one line and a three key confirmation? (75 characters including spaces and error handling, with the case in question)

Cheers guys I'll look for some of Domenics' posts.

[daddylonglegs]

Why use 17 lines of gobble-de-gook and press a few buttons when it can be done dynamically with one line and a three key confirmation? (75 characters including spaces and error handling, with the case in question)

My feelings too!

Cheers guys I'll look for some of Domenics' posts.

There aren't so many MMULT contributions here, although this is a good one if you have a few hours to spare

[Don't tell anybody I told you but you'll probably find more Domenic "pearls of wisdom" at Mr E*cel]

[NBVC]

I actually met Domenic in person a few months back.. We went for a coffee and chatted. He doesn't live too far from me.

[NBVC]

I kinda' left this regular hanging on this thread: http://www.excelforum.com/excel-gene...-countifs.html

he is trying to fix his VBA countif.. if someone wants to have a go at it....

[abousetta]

This one is above my comfort level with Change events. I have tried to tweak it but no dice. Maybe someone can jump in and assist the OP. Thanks.

[JBeaucaire]

On this thread I've given the op a WS_CHANGE macro to do some updating, but they need the macro to trigger with data being updated by a DDE link, something I've never used, so no idea how to bridge the idea if the DDE updates are not capable of triggering a ws_change macro.

[TMS]

http://en.allexperts.com/q/Excel-105...-Real-time.htm

Seems a DDE "event" triggers the Worksheet calculate event.

Regards

[zbor]

A challenge: http://www.excelforum.com/excel-work...t-streaks.html

[davegugg]

I feel like there should be an easy answer for this, but it's not coming to me. OP wants to sort by Mem Last Name, but all Mem# need to stay together. Is VBA the only solution?

[Kyle123]

Anyone fancy a crack at this? I've run out of patience http://www.excelforum.com/excel-prog...ng-arrays.html

[ChemistB]

I think this might be possible with a formula but more likely VBA. It's an interesting poser.

http://www.excelforum.com/excel-gene...-work-hrs.html

[Steffen Thomsen]

Can someone take over on this one?

how-to-replace-a-date-in-a-macro-module.html

[arlu1201]

I am stuck with this one -

http://www.excelforum.com/excel-prog...-with-vba.html

[alansidman]

I've given the OP a formula solution but it is based upon static dates. My VBA skills are not up to giving him a dynamic solution. Anyone here up to the challenge. What I gave him works, but I think that there may be a cleaner solution in VBA

http://www.excelforum.com/excel-work...ml#post2635955

Attached is a spreadsheet that I developed it on, but did not give to the OP. Just in case, so you don't have to re-create.

Alan

[jeffreybrown]

Kind of figured there was more to it...

http://www.excelforum.com/excel-work...tinuously.html

Any thoughts?

[TMS]

@jeffrey:

suggested: =IF(SUMPRODUCT(--(B1:J1<>0),--(B1:J1<A1:I1))=0,"yes","no")

Regards

[jeffreybrown]

Anybody have Excel for Mac and could offer the correct solution for this?

[arthurbr]

Hi Guys
can anyone helpd with this thread http://www.excelforum.com/non-englis...e-donnees.html

OP would like his sheet to display automatically 8 rows by 5 cols then a 10 sec pause, then the next block 8*5 until all rows have been shown, then start anew.

[TMS]

@arthurbr: I have proposed a solution:

http://www.excelforum.com/2636899-post5.html / http://www.excelforum.com/2636902-post6.html

Regards, TMS

[arthurbr]

Thx TM, didn't know your French was that good !

[TMS]

@arthurbr: it's not ... I can do th basics but I need a lot of hints ... Google does that

Regards

[davegugg]

Can someone please jump in here. For some reason, I just can't put together what the guy is looking for.

[TMS]

@DaveGugg: I've had a look at the thread and the OP has posted a zip file with a workbook. This has formulae, as requested, but no code anywhere in sight.

Just looking at the code excerpts in the thread, it doesn't actually look like a worksheet change event. It's not monitoring any cells so, every time a cell is changed it's going to loop through nearly 5000 rows.

I'm wondering if the OP has just called it a worksheet change macro because IT changes the sheet.

Sorry, think I'll hang back on this as I have nothing constructive to offer.

Regards, TMS

[TMS]

Please can someone have a look at this Numerical Sorting thread?

It's a lookup/ranking with duplicates. I've provided the simple INDEX/MATCH with the intention of going away and finding the solution that caters for the duplicates. I know I have an example somewhere but it must be buried in the archives and I've wasted too much time looking for it.

Thanks, TMS

[alansidman]

I've maxxed out on this one. Automation from an Excel perspective is probably what is needed with links between Excel and Access instead of imports/exports. If you a have a solution, feel free to jump in here.

http://www.excelforum.com/excel-gene...ess-query.html

[martindwilson]

cant get this to work
http://www.excelforum.com/excel-gene...t-formula.html
is it doable without addin/code?

[MarvinP]

Hi,

Are there any Drag Racing Fans out there?

I get little credit for my suggestions on
http://www.excelforum.com/excel-prog...formating.html
and someone else might be able to help.

[martindwilson]

http://www.excelforum.com/excel-gene...ml#post2642790
i've made a pigs ear of this can anyone sort it pretty please

[Whizbang]

I am not sure why the formula stops working when the workbook is closed.


http://www.excelforum.com/excel-gene...-question.html

[Steffen Thomsen]

Can someone with experience in excel 2003 have a look at this thread

[davegugg]

Any ideas here?:
http://www.excelforum.com/excel-gene...-text-box.html

[NBVC]

If I am not mistaken, I think this one requires a bit of VBA expertise... to filter a Pivot table based on a list of possibilities rather than just one...

http://www.excelforum.com/excel-prog...ml#post2647815

[arthurbr]

Can anyone help on this one (VBA) http://www.excelforum.com/excel-prog...selection.html

[arlu1201]

Need help with this - http://www.excelforum.com/excel-prog...-criteria.html

[snb]

Need help with this - http://www.excelforum.com/excel-prog...-criteria.html

Not anymore.

[arlu1201]

U r great SNB....no one can beat u in this..

[darkyam]

I could use a hand with this one: http://www.excelforum.com/excel-gene...ml#post2646106. One of these days, I might even learn VBA myself.

[MarvinP]

Hey -

Should I have told this OP that he needs Access instead of Excel?
http://www.excelforum.com/excel-prog...n-formula.html

Any ideas on how to structure his data better so it is easy to subtract used parts from the total of his inventory? Have you used an Excel Inventory Template that would handle this problem?

I'm feeling a little guilty for him not having success I guess we can't help eveyone

[darkyam]

From reading his initial description, Marvin, I think yes, Access is a much better tool for this sort of thing. The need to be able to undo a transaction or look at it line by line further strengthens that opinion. The OP probably won't like hearing that, but any other way sounds like stitching something together after skimming all the posts and seeing the issues.

[jeffreybrown]

http://www.excelforum.com/excel-prog...ml#post2649194

I have probably butchered this, but it seems to work. I am using a function to return the numbers seperately from the letters and then running the formula's down the columns using this....

Please Login or Register  to view this content.

...The OP asked if it can be more dynamic so I'm using the activecell.column and then offsetting the columns from there. The part I always have problems with is how to insert columns by the numbers instead of letters.

Please Login or Register  to view this content.

Instead of the above I would want to offset the columns to be added starting from the activecell.colunm. In this case it would offset from column 1, so, column 2 and 3.

Hope this makes sense

[TMS]

@Jeff: maybe:

Please Login or Register  to view this content.

Regards

[Domski]

Anyone fancy a challenge?

http://www.excelforum.com/excel-prog...ml#post2651240

Dom

[TMS]

@Dom: even if you had downloaded the attachment, I doubt it would have helped that much.

A lot to do, step by step, through the medium of the forum. Way too much work. Sorry.

I think RS nailed it ... pay a consultant.

Regards

[Domski]

I assumed that would be the case but thought it a bit unfair to write it off without someone at least looking at the attachment.

Dom

[jeffreybrown]

I've seem to run out of gas on this one

I could probably rearrange the sheet somehow, but maybe there is a smarter way.

Any thoughts?

[tigeravatar]

@jeffreybrown: I posted a reply, though now that I've written it up and tried to explain it, I probably went a little overboard >_< Hopefully the OP finds it helpful...

[darkyam]

Tigeravatar, I've noticed you using offset in a couple posts. Generally, it's better to avoid it when you can and opt for Index/Match instead. In this last one, the named range could be =Table!$A$2:INDEX(Table!E:E,MATCH(99^99,E:E)) and your last formula could be =IF(OR($C$1="",C3=""),"",SUMIFS(Table!D:D,Table!A:A,$C$1,Table!B:B,$B3,Table!C:C,$C3)). The main reason to avoid offset is because it is a volatile function, so it calculates with every change in the workbook rather than just changes that affect the cell the formula is in. It may not be a big deal with a smaller sheet, but it can eat resources in a larger one.

[darkyam]

Confused about this one: http://www.excelforum.com/excel-gene...ml#post2653162

I pull up the OP's workbook and it works just fine for me. I can't replicate his issue on my computer. Anyone else know what might be going on?

[Mordred]

Hi all, I was asked to delete this thread by the person that started it but it is not resolved and I have no idea. Perhaps someone can solve this?

[NBVC]

If anyone can help on this one.. it's all yours:

http://www.excelforum.com/excel-gene...80#post2662580

I am getting a headache with it and it's almost time for me to say good-night.

[JBeaucaire]

This OP asked a followup Q in post #6 I have no experience with. Any input would be appreciated.

http://www.excelforum.com/excel-gene...54#post2662154

[NBVC]

Here's another one for you VBA guys .. at least as I understand the problem, I think it needs VBA.

http://www.excelforum.com/excel-prog...ific-date.html

[Kyle123]

Can anyone help here please?

I think the OP has Excel 2007 onwards and doesn't know how to make a macro enabled workbook, unfortunately - neither do I

hehe: link might help -http://www.excelforum.com/excel-new-...addresses.html

[arlu1201]

Where is the link Kyle? Anyways while saving the excel 2007 file, there will be one option available called "Macro enabled (xlsm). Just select that from the dropdown and save the file with a name.

[abousetta]

second option would be to save as a binary file (*.xlsb).

abousetta

[romperstomper]

Or .xls if you want backward compatibility.

[abousetta]

RS... I just thought of that and came back to post that same thought... Guess I wasn't fast enough

[ChemistB]

I'm stumped.

http://www.excelforum.com/excel-gene...ted-sheet.html

Thanks all.

[Mordred]

See here as this person wants to skip along ActiveX comboboxes after entering a value from the first combobox. I misunderstood the situation and provided an example that works with a userform but not sheet side ActiveX comboboxes.

[arlu1201]

I need help with this one - http://www.excelforum.com/excel-prog...-workbook.html. Have drafted a code for the OP as well but its not solving the problem completely. See the last post in the thread.

Please help this person, whoever can.

[arlu1201]

Another one - convert excel sheets to PDF files...not sure how to get this done. http://www.excelforum.com/excel-prog...-to-pdf-2.html

Thanks much

[Mordred]

This guy is looking for some serious help and I am lost to provide it . See here.

[abousetta]

This one is above my abilities... the data is inconsistent and there are comma and semicolon delimiters. The data is really a mess and I don't know how to clean it up without some loss. I think he just has to get a really big cup of coffee and do it the old 'really hard' way

abousetta

[Marcol]

Could someone look at this please?
Date validation to give error when nothing is filled in
I thought it would be easy, but either I'm having a mental block, or it's not so straightforward.

Thanks

[jeffreybrown]

Would anybody have any suggestion's here?

http://www.excelforum.com/excel-2007...-each-row.html

[arlu1201]

Need help with this one -
http://www.excelforum.com/excel-gene...-workbook.html

[TMS]

@alu1201: several responses to the post (http://www.excelforum.com/excel-gene...-workbook.html)


Regards, TMS

[arlu1201]

Great...i guess it was easier for others than i could handle it. VBA is fine with me...but this index n match eats my head up.

Thanks for the help.

[JBeaucaire]

Can someone take a look here and offer ideas I'm not thinking of... or confirm my fears?

[Whizbang]

This one needs some help. He is almost there. I just don't have much experience with charts.

[arlu1201]

Need help with this one - http://www.excelforum.com/excel-gene...ta-shange.html

Looks like more of a indirect - match - index solution. It will take me a long time to get this working, as i dont have much experience with these formulae.

[arlu1201]

Need help with this one. I have the overall idea how it can be done, but never worked on such logic to get the code working.
Can anyone help here - http://www.excelforum.com/excel-prog...-in-excel.html
I will be glad to learn something from this as well.

[grizzly6969]

hay guys I,m drawing a blank
http://www.excelforum.com/excel-gene...d-vlookup.html

[Domski]

Anyone fancy a go at this?

http://www.excelforum.com/excel-gene...readsheet.html

I'm a bit busy at work at the moment.

Dom

[TMS]

Can anyone help with this, please?

Help with a VLookup and using formula in cell

I thought I was making progress but I am completely lost.


Thanks TMS

[JapanDave]

Can someone help me with this,
Run Macro from different Workbook

This is over my head and I don't know if it is even possible???

[Domski]

Shouldn't tax someone too much. I'm back on strike...

http://www.excelforum.com/excel-prog...-subtract.html

[jeffreybrown]

I'm not seeing this one. Anyone have some ideas...

http://www.excelforum.com/excel-prog...html?p=2692635

[jeffreybrown]

Must not be my day. My brain has failed me here and surely not the only place.

http://www.excelforum.com/excel-prog...html?p=2692891

[Mordred]

Hi all, this thread shouldn't be a problem with summing times but for some reason it is. I have

Please Login or Register  to view this content.

to do the dirty work but the sum is always 00:00:00 and I don't know why. In his/her workbook I used a filter on his/her Account Code and then I was hoping that my code would do the rest but I am at a complete loss on this one.

[tigeravatar]

Mordred, its because the "numbers" in column B are text, not numbers. You'll have to convert them to numbers first, and then your macro should work.

[dangelor]

Column B is text.

[Mordred]

I tried that and still get 00:00:00

[pike]

times are a challenge

Please Login or Register  to view this content.

[pike]

ops tested this one

Please Login or Register  to view this content.

[Mordred]

That's genius pike but I am not referencing the filtered rows properly. I realize it is because I am using

Please Login or Register  to view this content.

but the beginning of this range is wrong. What it needs to be is the filtered range start which could be any row depending on selection. The total code that I have (with yours) is

Please Login or Register  to view this content.

and yours

Please Login or Register  to view this content.

[OnErrorGoto0]

Use an array of type Double, populate that with the time values, then sum it.

[snb]

or ?

Please Login or Register  to view this content.

[arlu1201]

Need a lil help with this one - http://www.excelforum.com/excel-prog...17#post2693317 - I have created the code which will copy the specific rows to the "Action" tab. However, now the user is asking for a specific validation with respect to the radio buttons. If either Yes or No is selected, then the user HAS to put a score in the score field and then the copying should proceed.

I have never worked with radio buttons directly on an excel sheet (have used it in forms) so need a lil help here. The number of rows can vary from sheet to sheet and so will the radio buttons on each page. How do i check for each radio button?

[Kyle123]

Morning Arlette, I've replied in the thread, the easiest thing is just to check the value of the linked cell

[Alf]

Hi

I have a problem with this thread http://www.excelforum.com/excel-prog...ent-sheet.html

Tanks to jaslak the OP’s problem is solved but I can’t understand why the OP’s results differ so much mine running my code.

We both use Excel 2007 and even if the OP lives in Mumbai and me in Scandinavia (my Excel 2007 is an English version by the way) I hardly think this is what causes the problem.

The code is quite simple. It first checks if there is sheets not named “INPUT”. If so sheet is deleted.

The “INPUT” sheet is then copied and renamed to create a template sheet as the layout and formatting on the “INPUT” sheet was a bit unusual. Data is also removed from template sheet.

Column E on “INPUT” sheet is copied and the names are trimmed (lots of trailing spaces in this data) and sorted unique (tanks Tom Ogilvy) on sheet “Analyze”.


The code then loops through all the unique names creating a sheet with that name, setting an autofiler in the “INPUT” sheet using the unique name as the filtering criteria and copies the filtered range to the created sheet.

Finally the code deletes the “Analyze” and “Templ” sheets and sorts all sheets added after “INPUT” sheet.

The file that the OP mailed back to me showed that data on the four sheets created was the same as on the “INPUT” sheet. So either no filtering was done or the wrong area was copied.

At that time I used

Please Login or Register  to view this content.

for transferring data but even if this works well in Excel 2003 I’ve had some problems with it in Excel 2007 so I changed to

Please Login or Register  to view this content.

that also runs without any problem on my PC but for the OP the same problem persist he tells me.

So gentlemen could anybody please solve this problem for me and tell my why this code does not seem to work outside Scandinavia.

Alf

[tigeravatar]

Hello all,

I created a UDF for this thread, and now user needs the same functionality but faster/more efficient. I took a look at the links Marvin posted, but I can't seem to use the information provided there to get the UDF faster

[JBeaucaire]

I'm drawing a blank on this thread, and would be interested in knowing how to do this.

In a nutshell, how to construct the Array(Array(), Array(), Array()) syntax that Text To Columns Fixed Width uses by placing the array values into a table of cells, then feed that into a texttocolumns command at the FieldInfo:=...

[pike]

hi jb do you mean like

Please Login or Register  to view this content.

[JBeaucaire]

hi jb do you mean like

Please Login or Register  to view this content.

No. That just transposes on array to another. I'm trying to answer the OPs request to take a table of values

Please Login or Register  to view this content.

...And use those values that to construct a usable array to feed into the FieldInfo:= parameter of a TextToColumns command so that the strings in column A are parsed using those array values:

Please Login or Register  to view this content.

...and have the TextToColumns command work. The op has indicated that each time they run it, the number of values in the array R:S will be different because the column A values will be different

[pike]

maybe....

Please Login or Register  to view this content.

[protonLeah]

Does this one work?

Please Login or Register  to view this content.

I used sheet2 to hold the array data from the example.

[JBeaucaire]

@ProtonLeah, no, I tried something like that at first to no avail. Should this discussion be going on in the other thread?

Note: I know how to do this with a looping code that splits the strings manually, this is purely intended to discover if the OP's original question can be answered... can an array be created by values in a table that is then fed into the FieldInfo variable to split column A strings. I can't do it.

Here's my adjustment to your code to match the test:

Please Login or Register  to view this content.

[snb]

I'd prefer:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

or if you want to specify the limits in VBA and not in a worksheet:

Please Login or Register  to view this content.

[jeffreybrown]

I'm getting a little more comfortable with some formulas, but I don't know how to proceed from here...

http://www.excelforum.com/excel-prog...html?p=2700000

[arlu1201]

Need help with this one. I have no experience with linking excel to non-office apps.
http://www.excelforum.com/excel-gene...ease-help.html

[NBVC]

If anyone wants to take on a VBA question... here you go.... http://www.excelforum.com/excel-prog...016&viewfull=1

[JBeaucaire]

I have to admit I'm not grasping what the OP is asking in this thread.

[JBeaucaire]

Someone doing MSDOS text exporting, not really fluent in that. Check here if you can help.

[dangelor]

Beyond my narrow experience. This one needs a chart expert...

http://www.excelforum.com/excel-prog...01#post2705501

[jeffreybrown]

I can't wrap my brain around what this OP wants...

http://www.excelforum.com/excel-gene...r-to-plot.html

[arlu1201]

This OP needs the row to be inserted wherever the user clicks. The formulae from the previous row need to be inserted. This is fine and i am comfy working with it.
But i get stuck when it comes to updating the sum formulae to include the new row.
http://www.excelforum.com/excel-2007...-formulas.html

[zbor]

Anybody have some idea for:

http://www.excelforum.com/excel-work...44#post2709444

I've tried but always looped myself more than a file

[NBVC]

I gave this guy a nifty solution... but he wants VBA instead..... anybody? http://www.excelforum.com/excel-prog...-criteria.html

[Mordred]

Can someone explain to me why a worksheet change event won't work if the the cells are updated(changed) via DDE link as per this thread (post 10)? When I set up the workbook that I uploaded to the OP, I tested the Target range with one of the cells in that range as the following

Please Login or Register  to view this content.

and when I changed around Sheet2's value, the worksheet change event ran properly. Is there or was there validity to the other person's apprehension to using the worksheet change event?

EDIT: Now it isn't working but it most definitely was. Oh how I love the inconsistencies of Excel.

[OnErrorGoto0]

Formulas only trigger a change event when you initially enter them. The rest of the time they only raise a calculate event.

[Mordred]

That makes perfect sense. Thanks.

[OnErrorGoto0]

I think with DDE you can use the OnData property of the worksheet, but the asker seems to have resolved it anyway using Calculate. If it's only a few cells you could also try linking activex controls to the cells and using their change events.

[JBeaucaire]

Anybody get what this guy is asking now: http://www.excelforum.com/excel-work...35#post2712935

[arlu1201]

Need help with this thread - http://www.excelforum.com/excel-gene...p-of-text.html

The OP needs sorting to be done in the .txt file. Can i open it in excel and work with it? Or should it be done directly in the text file? Am stuck.

[NBVC]

Another one who insists on a VBA solution rather than a Excel formula/feature based one....

http://www.excelforum.com/excel-prog...in-sheet1.html

[tigeravatar]

For some reason my macro seems to be converting dates to US format regardless of regional settings in this thread:

http://www.excelforum.com/excel-prog...html?p=2717645

[Domski]

Can someone pick this up please:

http://www.excelforum.com/excel-prog...01#post2717401

I'm out on the lash all weekend and will have forgotten my name by Monday let alone this

Darth Domski

[TMS]

@Dom: no dedication

[abousetta]

Anybody familiar with the vba syntax for combo boxes placed in worksheets want to help out the OP here? He's not asking much, but I can't get the syntax right.

[arlu1201]

Need help with this...http://www.excelforum.com/excel-prog...wo-sheets.html

Helped with the initial requests, but am lost with the additional requirements.

[mikecox]

[QUOTE=teylyn;2459308 (remember to post a link to the thread ).[/QUOTE] How would I do that?