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

[martindwilson]

http://www.excelforum.com/excel-gene...wer-needs.html
im not even sure what op is on about,calculations seem reasonable ..

[jeffreybrown]

I have not the slightest idea here

http://www.excelforum.com/excel-gene...51#post2903451

[JBeaucaire]

Anyone with a non-64bit computer able to assist with the VBA question in this thread?

[ChemistB]

VBA Skills needed
http://www.excelforum.com/excel-gene...ngle-cell.html

[Dave H9]

Can someone help here please. Requires either pivot knowledge or an elaborate index/match formula?

Thank you

Dave H

[vandan_tanna]

OP needs more creative solution here

[icestationzbra]

please see if someone can help here:

http://www.excelforum.com/excel-gene...ied-dates.html

EDIT: i provided a helper-column-based solution. if someone has a better approach, please offer.

[jeffreybrown]

Don't even know where to begin or what to ask...Any takers?

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

[arlu1201]

Maybe a formula solution here -

http://www.excelforum.com/excel-prog...c-content.html

[JBeaucaire]

In this thread:

http://www.excelforum.com/excel-form...onditions.html

I have provided a working formula, but it's a real dog. If anyone has a better, more elegant way of accomplishing this, please offer it. VBA I could do, looking for better formulas if they can be had.

[JBeaucaire]

Admittedly, my skills with REDIM PRESERVE of arrays to expand on demand is... at best... a C-, can someone who breathes those a little more full take a look at this thread:

http://www.excelforum.com/excel-prog...le-sheets.html


A macro that uses to work on one sheet I've demonstrated how to make it cycle through all worksheets, but the line having to do with creation of an array needs to be converted to "expansion" of an array as a result. Thanks in advance.

[jeffreybrown]

Anybody want to take a crack at this? The OP can use the worksheet change event, but they still would like another method.

http://www.excelforum.com/excel-prog...-open-row.html

[JBeaucaire]

Need help... this OP is using a data Connection method I've never seen before and do not seem to be able to actually test the code presented.

http://www.excelforum.com/excel-prog...iple-urls.html

The post #1 lists the URLs listed in column A, and the results of the code in post #3 are supposed to insert answers down column B. I can't fathom how to create the loop that will insert the URLs from column A into the popup that the code current creates. Looking forward to learning more about this connection type.

[Kyle123]

Hmmm, I've seen iqy connections before, but I'm confused as to why the OP wants to use one - seems a bit complicated. I think he may have created a generic web query incorrectly

I've posted an alternative that's quite a bit easier.

[zbor]

I don't get what he wants: http://www.excelforum.com/excel-prog...nd-insert.html

[zbor]

I don't get what he wants: http://www.excelforum.com/excel-prog...nd-insert.html

[tom1977]

If someone knows the solution here:
http://www.excelforum.com/excel-gene...html?p=2926011
I would be also interested in

[TMS]

@zbor: see the thread - probably needs to insert after the active cell/row.

Regards, TMS

[arlu1201]

Need some help with this one -

http://www.excelforum.com/excel-prog...xcel-file.html

[ChemistB]

Need a chart or graphing guru for this one. Thanks

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

[JBeaucaire]

Any comments here? http://www.excelforum.com/excel-prog...-to-lists.html

[arlu1201]

Need some help here, not worked with splitting data based on line feeds -

http://www.excelforum.com/excel-gene...iple-rows.html

[ChemistB]

Using an Array formula and UDF to Concatenate a range based on criteria but having trouble removing excess separators.

http://www.excelforum.com/excel-gene...ate-range.html
Thanks

[ChemistB]

Not sure what is going on with OPs system. Maybe a setting I am unaware of? or it's corrupt. In any case, it refuses to format the cell as accounting. When I do it and send it back, it's working but OP sees it as custom formatting.

http://www.excelforum.com/excel-gene...ng-option.html

[martindwilson]

http://www.excelforum.com/excel-prog...uplicates.html
can someone put him out of his misery?

[shg]

Lottery numerology -- tiresome, barren, and endless.

[FDibbins]

not sure what the OP wants, can any1 understand/help?

http://www.excelforum.com/excel-form...html?p=2933864

[Accountant1234]

I entered this post last week and no one has responded. I'm wondering if it's because I responded to myself to make an adjustement, so people aren't reading it. If anyone has any suggestion I would GREATLY appreciate the help.

http://www.excelforum.com/excel-form...w-numbers.html

[ChemistB]

http://www.excelforum.com/excel-new-...lues-rows.html

OP needs a VBA solution. Seems as easy as adding a line to check sheet2 to see if duplicate and, if so, move to next cell, but I'm a formula guy.

[stojko89]

The user is asking if its possible to run macros in a .xls file.
I kind of answered no but I don't know if I'm wrong in some way if there is a way around it?

http://www.excelforum.com/excel-gene...19#post2935019

[JBeaucaire]

.xls is Excel 95-2003 format, it allows macros with no special file format requirement. The File Format requirements were introduced in Excel 2007+.

[mike7952]

Can someone help me with this post. Im lost

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

[tigeravatar]

Mike,

The problem is you are having him use whole columns in an array formula. Excel 2007 and higher can work with whole columns in an array formula, but not Excel 2003 which is what that user is working with, which is why the formula is erroring for him, but not you. Have him limit the ranges to just where the data is. So instead of payment!B:B it would be payment!$B$3:$B$5 (and same with the other whole column references) and it should work for him.

As a side note, limiting the ranges is always recommended when working with array formulas because they are so processor intensive, and calculating results for every row in a column is not good practice.

[EDIT]:
Alternately, instead of whole column references, you can use a dynamic named range. That way the search range is limited to just the cells that contain data and the search range grows as data is added, thus overcoming the limitation of using limited ranges while not resorting to referencing the whole column.

[mike7952]

Thanks tiger notes taken.

[mike7952]

Im not very good with formulas and dynamic named range. Im normally just into vba data manipulation. The OP orginally asked for a Macro solution. I guess I should of just coded something up.

[tigeravatar]

Its easy to stay where we're comfortable. I think its really cool that you took the initiative to try a formula solution instead of just going for the macro. It lets you learn and increase your skillset when you might otherwise have stagnated. 'Sides, that's what this thread is all about, asking for help when we run into a wall. I've asked for help here myself, and it has always been well worth the learning experience.

[TMS]

@Mike: since I learned how, I tend to use dynamic named ranges a lot unless it is definitely a fixed range.

I use INDEX rather than OFFSET as OFFSET is volatile and INDEX isn't.

A dnr for cells in column A:

=$A$2:INDEX($A:$A,COUNTA($S:$A)) ... this assumes that you have a heading in row 1 and no blank cells

Similarly, a dnr for cells in columns A to D:

=$A$2:INDEX($D:$D,COUNTA($S:$A)) ... same assumptions plus the belief that column A is the key field. It also means that blank cells in columns B to D are unimportant.

dnr in this case is Dynamic Named Range as opposed to Do Not Resuscitate.

I sometimes prefix the name of the range with dnr or dr or just r to indicate that it is a named range ... just for ease of identification


Regards, TMS


Edit: note that, if there are blank cells, there are ways around it so it's not the end of the world.

[TMS]

Please can someone take a look at this thread. I just can't get my head around a formula to cater for these date calculations.

Proper Counting of Days

Thanks, TMS

[JosephP]

I use INDEX rather than OFFSET as OFFSET is volatile and INDEX isn't.

A dnr for cells in column A:

=$A$2:INDEX($A:$A,COUNTA($S:$A))

INDEX in that syntax is semi-volatile -it will recalculate when the workbook opens

[Russell Dawson]

http://www.excelforum.com/excel-gene...50#post2937650

This has been dormant - awaiting upload. Unable to spend time now myself.

[stojko89]

Can anyone help me with a part of the pussle in this thread? http://www.excelforum.com/excel-prog...87#post2937987
I'm making a new collection list for the next combo box but I would need to clear the new collection before making a new collection

[arlu1201]

Need a lil help here. The solution is almost done. But i need to merge entries for the users ...for e.g. Debbie shows as Debbie & Debbie 【代講】The macro is not identifying the Japanese characters. The user wants all entries for Debbie and Debbie 【代講】 to show up in one sheet. How do i do this?
http://www.excelforum.com/excel-prog...olumn-d-2.html

[arlu1201]

Another one where i am stuck. Not worked much with forms. When updating the existing data, the listbox control interferes with the updates to only 2 fields - first name and last name.
http://www.excelforum.com/excel-prog...worksheet.html

[stojko89]

arlu for the second thread I did a little twist of the code
Hope it works.
And I hope that this is what he wanted hehe

[arlu1201]

Thanks Stojko.

[pucval]

Can someone help me with this thread?

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

It is quite urgent for me

Thanks friends


P.S. you can post your possible answers in the thread it self, I will be there

Regards,
Pucval

[arlu1201]

Need some help here. http://www.excelforum.com/excel-prog...readsheet.html Never worked with excel based search engines Got a PM from a user that he is pretty frustrated that he is not able to work it out and he is not receiving any solutions.

[Red fuji]

I am not sure if it is ok to post my unsolved issue here - it is been only two days but it is falling down the list i am afraid it is going dead. Unless someone has been working on a solution durning those two days and testing it out tyring to get it to work-if that's the case i owe that person a big favor. but at this point i dont know if i am ever getting a reply- it has been getting a ton of hits but no response as of this writing. It is a rather complex problem and I dont blame anyone for not wanting to go near it-i can understand. after all everything is done gratis and as far as i know no one here works for me or owes me a thing. I can only be thankful for the existance of this forum. I been constantly checking the thread hoping for an answer but i am losing hope but havent giving up. Thanks.

http://www.excelforum.com/excel-gene...n-problem.html

[tigeravatar]

I'm not sure what else I can offer on this one:
http://www.excelforum.com/excel-prog...html?p=2940325

Anybody else fancy a crack at it? Perhaps an alternate method/solution is warranted

[FDibbins]

heres an interesting 1, any1 got any suggestion?

http://www.excelforum.com/excel-form...html?p=2939958

[jaslake]

@FDibbins

A screen shot is not particularly helpful. Have the OP post the WORKBOOK from which the screen shot was created...perhaps that'll give you some ideas.

[pucval]

Hi firends,

Can anyone check my problem?

http://www.excelforum.com/excel-prog...70#post2940570

Thank you in advance,
Pucval

[Tsjallie]

Not sure about the rules for this thread, but I guess I can post here to draw specific attention to an issue I posted about one week ago.
See http://www.excelforum.com/excel-prog...html?p=2938739
Put in a small demo that shows exacly the problem. Not even 1 view of it. Have been bumping it twice, still no response.
Pretty frustrating I must say.
There must be someone who can say something usefull about this issue.

[FDibbins]

can any1 help with this please?....

http://www.excelforum.com/excel-form...html?p=2941136

[JazzBalmain]

Hello

I'm very new to forums and so I'm a little lost in what to do. I have an excel problem which I posted last week but have had no replies to ... it may be that I've not explained it very well or that I've included an attachment (I know I'm always a bit wary of downloading attachments). Anyway, I desperately need some help as I've been working on this night and day for over a week and haven't found a solution. Would someone here be able to help me and is there a particular place I should place my post?

Really appreciate any assistance you can give me as I've now bitten off my nails and am now chewing on my fingers :-)

[arlu1201]

Need some help here - http://www.excelforum.com/excel-prog...-non-form.html

The user responded in the intro section that no one has responded to his question since 9/5.

[jeffreybrown]

Anybody have an idea here...?

http://www.excelforum.com/excel-gene...by-groups.html

[JBeaucaire]

Can anyone give this OP some assistance: http://www.excelforum.com/excel-gene...ml#post2943049

They're looking for a formulaic solution which escapes me at the moment. I'm seeing if anyone else has an idea or two before I push as VBA solution on him.

[ChemistB]

Not even sure what the issue is here but I'm definitely in over my head.

http://www.excelforum.com/excel-new-...workbooks.html

[arlu1201]

I keep getting VMs or PMs from this user stating that no one has replied. http://www.excelforum.com/excel-form...-in-excel.html Can someone plz look into this thread?

[HaHoBe]

Can anybody point out what I´m obviously missing: http://www.excelforum.com/excel-prog...g-a-macro.html

[Orestees]

Great idea. Can anyone call in the cavalry, or just mods and such?

[tigeravatar]

Excerpt from the first post in this thread:

... we may get stuck in a thread and need help from other members to solve a problem, and we hope that someone else will come along, have a look at the situation and provide some fresh insights that can lead to a solution.

Therefore, I'd like to start this thread for all members of Excelforum.

...

If you find yourself in a situation where you can't provide a working solution for the Original Poster (OP), but you think that a solution could be achieved with the help of some other members here, you can post a reply to this thread and ask other members of Excelforum to go have a look (remember to post a link to the thread ).

So this is meant for anybody to use

[shg]

But meant for you to help someone else, not for someone else to help you.

[jeffreybrown]

Looking for some guidance here. I've set this OP up for an advanced filter (VBA), but the OP would like to use a wild card. I can't see this as possible in VBA with the advanced filter or am I missing something? Maybe a filter instead?

[stojko89]

Can some1 help me with a tincy problem? Thread Link
I've just uploaded a workbook to the user back.
My problem is I don't know how to make it when he types "Completed" in a cell to take the action.
I've made it so when he clicks a cell and if that one contains "Completed" then it does stuff

[stojko89]

Thanks Zbor but that still wasn't what I was looking for hehe.
I tweaked the code a bit with your code that helped works bouth ways my way and yours.
But I was looking for something else...but the user is satisfied so I guess never mind then

[ChemistB]

OP says you can't reverse the order of the x axis on 2007. I have 2010 currently (which allows it). Any 2007 users out there?

http://www.excelforum.com/excel-gene...hart-help.html

[JosephP]

op is mistaken: http://office.microsoft.com/en-us/ex...48557.aspx#BM1

[stojko89]

Can some1 help this guy out? I gave him a code but then we noticed a problem that he has duplicat values that he wants searched so my code doesn't do it.
Link

[stojko89]

Thanks JBeaucaire

[JBeaucaire]

In This thread the OP is looking for a way to find the most frequent number in a worksheet with millions of numbers. The problem is he is looking for the most permutated number. So he's wanting to count 1234, 2141, 2413, 3214 (etc) as the same answer. All permutations of 1-2-3-4 would be detected and counted, then the most frequent permutated number is given as the answer.

I'm at a loss on how to advise them. This seems like a macro that would be cripplingly slow. Anyone have some ideas on how to accomplish?





It is not a duplicate of this thread.

[TMS]

@JB: one vague, half formed idea is to read all the numbers into an array and check if the total of the digits is 10 and the digits are unique. Of course, that starts to fall apart if there are less digits, more digits, different digits, the digits are intentionally not unique ... for example, if the OP decided he wanted combinations of 2288.

Anyway, back to the original idea; if the value matches the two criteria, add it to another array ... or have a 2D array containing the combinations and the counters.

Just a thought as I can't think through the logic. And if there are millions of numbers, it might not be feasible.

Regards, TMS

[zbor]

I would sort them in array from smallest to largest so 1234, 2141, 2413, 3214 would become 1234, 1124, 1234, 1234 giving 2 unique.
Also there won't be problem with 2288 or 1111.

[jeffreybrown]

I've never ran across this so just not sure. Any ideas?

[alansidman]

This OP needs help that is beyond my skill bank. He was not initially clear in what his needs were and therefore his thread went unanswered for several days. I am sure that one of the VBA experts could jump in here with a solution.

http://www.excelforum.com/excel-prog...ss-import.html

[ChemistB]

Pasting from Word removes unlocked cell status. Are there any settings that can fix this?

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

[jeffreybrown]

I can't quite see what the OP wants in this chart, any ideas?

[ChemistB]

Sigh, I should be able to do this but having trouble. Need to brush up on my VBA and spend more time in the Programming forum.

http://www.excelforum.com/excel-form...pdown-box.html

[stojko89]

Can some1 help me with this one I'm loosing my mind because it won't copy values only. I've tryed a few things but I want to keep one line for copy pastespecial.
So I don't have to use the with sheet1 and with sheet2.
Link

[TMS]

Can anyone take a look at this and bail me out? I don't even think I speak the same language! I understand all the words but, when they're joined up in a sentence, it's completely lost on me.

Named Range syntax when working abstracted from worksheet cells

Thanks, TMS


Edit: >>> Kyle123, shg ... thanks for taking a look.

[ChemistB]

http://www.excelforum.com/excel-gene...rop-downs.html

[Ace_XL]

http://www.excelforum.com/excel-gene...rop-downs.html

Works just fine in 2010!

[TMS]

http://www.excelforum.com/excel-gene...rop-downs.html

But definitely not in Excel 2007. Once it has changed format, it won't go back. If you change the order it will stick with number format rather than date format.

Regards, TMS

[Kyle123]

Edit: >>> Kyle123, shg ... thanks for taking a look.

No probs , a bit of Excel is light relief/skiving for me right now, doing some awful stuff with joining lat/lon polygons in javascript and it's destroying my brain

[Ace_XL]

http://www.excelforum.com/excel-form...html?p=2955590

[Lacaycer]

http://www.excelforum.com/showthread...t=#post2957185

I've been stuck on this one for 3 days... new views on this thread are few and far between now. Help please!

[JBeaucaire]

Thought I had this one, but it bugs out as column B values lengthen and I can't figure out why.

http://www.excelforum.com/showthread...=1#post2955310


Column A - on dynamic list
Column B - a second dynamic list

Columns D:E - a formula-based (vba I can do easy) list of the combinations.

My sample with 3 names and 3 data makes a perfect set of 9... but as soon as you add a 4th or 5th "data" the list goes wonky.

Anyone got a better set of formulas, or spot where mine are failing?

[Tsjallie]

This issue is solved. Just needed to take the frames into account.

-------------------------------
I'm trying to help some guy with reading a webpage (see: http://www.excelforum.com/excel-prog...-required.html), but we keep running into the same error: "Error 91: objectvariable or blockvariable With not set".

Can someone pls check this code and see what's wrong with it.

Please Login or Register  to view this content.

[FDibbins]

this sounds simple enough, but maybe 1 of you could take a look please?

http://www.excelforum.com/excel-prog...90#post2958590

[TMS]

@FDibbins: see update in thread.

http://www.excelforum.com/excel-prog...90#post2958590


Regards, TMS

[FDibbins]

i saw that, and replied in the thread, thanls TM.

now i have another really weird 1 that i cant explain. it should be simple, but i cant see what the problem is

http://www.excelforum.com/excel-form...available.html

1st off, the sheet1 column E formula is returning text, so the vlookup wont work (fixed with +0). then, the values on sheet2 that the vllokup is based on, DO seem to be values (tested with isnumber), but the vlookup only works if you replace the calc'd sequence with actual values

any thoughts, any1?

[JBeaucaire]

I've tried to implement a very short version of the CreateObject("Outlook.Application") I'd seen SNB use in another thread and demonstrate on his VBA for Smarties web site, but I don't have Outlook so can't really test it, the OP says it is giving an error.

Can anyone test this and perhaps spot the problem with the short version of this technique? Is the error perhaps them not having Outlook installed either?


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

[john55]

JB, I tried yr code and it works fain without any error!

[stojko89]

Can some1 help him on? my hands are tied.

[jeffreybrown]

Anybody have any suggestions to offer...

http://www.excelforum.com/excel-form...-formulas.html

[jeffreybrown]

I just have no idea how to get there...

http://www.excelforum.com/excel-gene...14#post2960014

[Haseeb Avarakkan]

VBA, Advanced formula or cool tricks on here,

http://www.excelforum.com/excel-form...ta-in-row.html

[Dave H9]

Can someone help out here please. I tried one approach but it will not work for the OP.

Thank you

Dave H

[FDibbins]

ok this 1's got me. can any1 help with this?

http://www.excelforum.com/excel-form...html?p=2959093

[arlu1201]

I was able to help the user with one cell but now he wants the code to work for a range of cells / a column. But am lost.

http://www.excelforum.com/excel-prog...l-formula.html

[mike7952]

Can someone help with this and test my uploaded wb in Post#8. OP keeps getting

It is throwing an error. "compile error sub or function not defined". Line 9 where is says Split. I am using Excel 2003, does that make a difference?

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

[JosephP]

don't have 2003 here to test but there is nothing in your workbook or code that should cause that error as far as I can see. perhaps get op to run excel in safe mode and test your workbook again

[martindwilson]

oops i replied to this needs a bit of code anyone fancy a go
http://www.excelforum.com/excel-prog...ther-cell.html

[Sindhus]

Hi All,
Can anybody help in this thread? http://www.excelforum.com/excel-gene...-new-post.html

Regards,
Sindhu

[Ace_XL]

A little help and this should be done..

http://www.excelforum.com/excel-gene...html?p=2965309

[zbor]

I've used NBVC approach here and I would expect that it work... But I can't get any shape name....

http://www.excelforum.com/excel-prog...=1#post2967448

[jeffreybrown]

I cannot figure this one out...

http://www.excelforum.com/excel-prog...55#post2967555

[JBeaucaire]

I thought I was going to be able to suggest some amendment to his ACCESS query here:

http://www.excelforum.com/access-tab...ived-data.html

But I don't really know how to get all the information retained for a single hospital in a single row, I can do it in Excel, but not Access.

[FDibbins]

OP is looking for a way to hyperlink to a file that has # in it?

http://www.excelforum.com/excel-form...html?p=2968027

[jeffreybrown]

I'm sure there is a formula solution for this, but I have no idea...

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

[davidmurphy25]

is it reasonable to repost my own thread as a OP? when its bumped way down the new post list with no replies but 67 views? i hope its not inappropriate, but i seem to have stumped the forum on this:

http://www.excelforum.com/excel-prog...ws-change.html

I like it!....also some threads get bumped way down the "new posts" list if they haven't had much activity so maybe we can ask for help in there to get those threads solved or satisfied in some way.

[jeffreybrown]

Hi davidmurphy25,

From the forum rules...

If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum

[icestationzbra]

there must be a simpler approach than what i have offered - non-array, non-volatile.

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

[srinivassurapareddi]

Please reply me !

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

[Kyle123]

Easy tiger, you only posted that 10 mins ago! Give someone chance

[jeffreybrown]

Anybody fancy to figure why the dates on this chart don't quite read as the data indicates?

http://www.excelforum.com/excel-gene...is-labels.html

[WasWodge]

I have PM'd the OP to tell him/her that after looking at the data in Column F the number of tasks I can see to achieve the results they desire is too many for me to attempt on a forum, so if anyone feels like jumping in please feel welcome.

http://www.excelforum.com/excel-prog...ell-value.html

[Fotis1991]

Can anyone help with this?

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

[tigeravatar]

Anybody fancy a go at this one?

http://www.excelforum.com/excel-gene...html?p=2973358

[ChemistB]

I believe this one would be best served with some VBA. Thanks gang.

http://www.excelforum.com/excel-gene...el-layout.html

[jeffreybrown]

Okay, trying to setup an example to show the OP how they could loop through a collection of workbooks and use Ron's "GetData" macro to pull in a range from each closed workbook.

Here is what I have so far but I am failing miserably on the loop. Could I get a hand? Any suggestions?

Please Login or Register  to view this content.

http://www.excelforum.com/excel-prog...ook-issue.html

[mike7952]

Jeff looks like your missing the lngIndex

Please Login or Register  to view this content.

[jeffreybrown]

That was it Mike...Thank you very much

[mike7952]

Your welcome

[arlu1201]

This user PMd me saying that he has not got any response. I am not able to help him. Someone please - http://www.excelforum.com/excel-prog...g-results.html

Thanks much.

[jeffreybrown]

OP has completely lost me about finding the last row...

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

Anyone want to lend a helping hand?

[ChemistB]

This is an interesting problem and I will continue to work on it but I get the feeling it's over my head. Let's see if anyone else can crack this one. Depending on the % he picks, there may not be 60 unique picks. Read my last post for an explaination as the OP didn't explain things very well.

http://www.excelforum.com/excel-form...rcentages.html

[tigeravatar]

I created a UDF solution which accomplishes what the OP needs here:
http://www.excelforum.com/excel-prog...html?p=2983062

I really wanted to come up with a solution using just native formulas, but I can't seem to come up with one. Any insight for a native formula solution would be welcome.

[jeffreybrown]

I stink at checkboxes.

Any want a go at this...

http://www.excelforum.com/excel-prog...84#post2984284

[ChemistB]

Someone want to finish this up for me? I'm going to be off-line for a few days.

http://www.excelforum.com/excel-gene...n-by-year.html

[arlu1201]

Can someone please help this guy out ?

http://www.excelforum.com/excel-form...task-cell.html

[abousetta]

This OP's workbooks are in Croatian and he is on a mac. If anyone can help him out then that would be great (http://www.excelforum.com/excel-gene...89#post2985589).

abousetta

[arlu1201]

Can someone please assist here? This is way beyond me. Maybe an index-match solution, am not sure.

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

Thanks much.

[JBeaucaire]

No patience for this one, if anyone wants to take a crack at helping this OP with his more complex layout. I like my shorter approach, he doesn't.

[arlu1201]

The solution is ready and working fine at my end but the user is using a MAC and I am not. He is getting an error on the getopenfilename part. How do i change it? The most updated code is in post 41 of this thread - http://www.excelforum.com/excel-prog...-beyond-3.html

[jeffreybrown]

Does anybody want to tackle this macro?

http://www.excelforum.com/excel-prog...tain-rows.html

[jeffreybrown]

This OP has a chart showing data, but the data for the chart is embedded within the series values. I'm guessing he/she thought the data was once on another sheet. Any thoughts?

http://www.excelforum.com/excel-char...-my-chart.html

[FDibbins]

maybe someone else can understand what the OP wants? either im brain dead or tired, but i cant make it out

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

[arlu1201]

Can anyone help here - http://www.excelforum.com/excel-prog...ew-tweaks.html

[jeffreybrown]

Can somebody offer some assistance here?

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

[jeffreybrown]

I don't understand these requirements at all...

http://www.excelforum.com/excel-prog...53#post2994853

[icestationzbra]

i have offered an ugly solution; i hope someone can help beautify it.

http://www.excelforum.com/excel-form...s-formula.html

[ChemistB]

This guy has 80000 rows which locks up my computer when I try some standard solutions. Maybe VBA is the way to go.

http://www.excelforum.com/excel-form...html?p=2995462

[protonLeah]

Can some one look at this one. I don't have time due to class work:
Need Help using and understanding IF function

Thanks, Ben

[Dave H9]

Hi Guys,

I'm admitting defeat on this one. Can't work how to make the formula dynamic with the OP's layout.

Thread is here

As always,

Many thanks

Dave H

[jeffreybrown]

Anybody want to take this on?

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

[arlu1201]

Can someone please help this person?

Still unsolved from 9/9 - http://www.excelforum.com/excel-prog...hyperlink.html

[martindwilson]

i could do this with a few helpers but it would be messy anyone want to do a bit of code for it?
http://www.excelforum.com/excel-gene...e-columns.html

[JBeaucaire]

I have posted a puzzle challenge here:

http://www.excelforum.com/excel-form...other-rng.html

This has me both stumped and intrigued. Can you fathom a formula in H2 to replace the existing formula that also completely eliminates the helper column E?

[ChemistB]

Can't think this one through.

http://www.excelforum.com/excel-form...rmination.html

[Kyle123]

Can anyone help here http://www.excelforum.com/excel-prog...eferences.html please?

It's my question, but despite posting this here, MrE and SO, no-one's been able to give me a definitive answer

[zbor]

Can someone test my solution here http://www.excelforum.com/excel-form...ther-cell.html
It work for me

[arlu1201]

This user has still not received any help and is waiting expectantly - any one can help him out? http://www.excelforum.com/excel-prog...ew-tweaks.html

[arlu1201]

Regarding this thread - http://www.excelforum.com/excel-gene...25#post3006425

I created this worksheet event code for the OP -

Please Login or Register  to view this content.

However this event is not getting triggered and i am not able to find out where i am wrong. It maybe needing just a small tweak if someone can look at it, please.

Thanks much.

[JosephP]

the calculate event does not provide a target parameter-you would have to run the code every time the sheet calculates regardless of which cells update

[arlu1201]

Thanks JP. Kyle helped me to work it out. Got it sorted for the OP.

Will you be able to help the OP in post 754? He is frantic.

[JosephP]

looks like Dave is on it already. I'm kinda under the gun today but if he's still stuck tomorrow I'll take a look

[JBeaucaire]

No prior experience with UNICODE text files, anyone offer this guy a little wisdom?

[JBeaucaire]

This gent has already jumped ahead of my comfort level in his Form project, if anyone cares to lend more aid. I'm tapped.

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

[jeffreybrown]

I'm not sure how to get this chart as the OP requests. Could be easy but my brain won't let it be...

http://www.excelforum.com/excel-char...-charting.html

[alansidman]

I'm out of answers for this OP. Anyone here have some expertise with MS Query and would like to jump in?

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

[ChemistB]

Return multiple results within a cell based on match in Col A

http://www.excelforum.com/excel-form...up-if-etc.html

[davesexcel]

http://www.excelforum.com/excel-prog...42#post3011842

Select something from the cells below the black cells.
This triggers a loop that filters through each sheet then copies and pastes to the "SEARCH" sheet in column B.
The sheet name is supposed show in column A. and I can't get it working properly.

Need a new pair of eyes on this.

Thanks,

Dave

[dredwolf]

I think I worked myself into a corner on this one :
http://www.excelforum.com/excel-form...-new-post.html

I managed to get the count of series done, then got stuck on the counting of them...any help here would be much appreciated !

[dredwolf]

Thanks a lot for the save daddylonglegs, Much appreciated !

-Edit-

By the way, this thread is a Great Idea !

[J.McQ]

anybody able to help me with this:

http://www.excelforum.com/excel-gene...html?p=3009758

[shg]

Please don't post in this thread for help on your own threads.

[J.McQ]

Noted. It would seem that I've misunderstood the purpose of this thread.

[TMS]

@J.McQ: easy mistake to make. The basic idea is that, if someone has tried to offer a solution but run out of ideas, they call for backup. Often, if one person has started to provide an answer or guidance, others don't join in. This may be out of courtesy, or simply that people just look at unanswered threads. And, when we run out of steam, we can "call in the cavalry".

Regards, TMS

[jeffreybrown]

Is it possible I'm missing something here?

[jeffreybrown]

Anybody want to tackle a chart?

http://www.excelforum.com/excel-char...84#post3013084

[jeffreybrown]

You would think by know I'm a little better with charts?

Need some help here...

http://www.excelforum.com/excel-char...size-data.html

[jeffreybrown]

I've run out of options for this OP...

Any ideas?

[abousetta]

Class module needed here... I think.

abousetta

[jeffreybrown]

Anybody got a formula for this?

[FDibbins]

anyone got any ideas on this 1?
http://www.excelforum.com/excel-gene...ormatting.html

[jeffreybrown]

Anybody have a solution for dependent dropdowns?

http://www.excelforum.com/excel-form...30#post3017930

[arlu1201]

I provided the solution to the user but its not working for him. I cant see whats wrong with it, maybe an extra pair of eyes will help correct my code.
http://www.excelforum.com/excel-gene...ndition-2.html

[JosephP]

I reckon you wanted a change event instead of selectionchange

[arlu1201]

I tried the Change event too but its not hiding the rows.

[JosephP]

you were checking target.offset(0, 1) instead of target.offset(0, -1) for the annual/monthly value ;-)

[arlu1201]

Oops yeah. This sheet is backward I tried it now and it works. But TA gave an awesome code too.

[FDibbins]

can anyone help with a macro this OP needs?

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

[arlu1201]

Need some MAC related help here - Everything is done except the last part of the code. Can someone please help ? http://www.excelforum.com/excel-prog...-beyond-7.html

[FDibbins]

my VBA sucks, can anyone help here please?

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

[TMS]

@FDibbins: I have offered some advice in the thread.

Regards, TMS

[JBeaucaire]

This gentleman is looking for some array assistance. Any takers?

[alansidman]

This is way out of my league. If you have SQL experience with ODBC not employing MS Query, then this guy can use your help.

http://www.excelforum.com/access-tab...mand-text.html

Alan

[abousetta]

Anyone with a mac and wanting to assist? The OP can't use scripting.dictionary because not available on macs but there a workaround here but I can't get it to work. The original thread is available here.

Thanks.

abousetta

[ChemistB]

In over my head.

http://www.excelforum.com/excel-gene...read-only.html

[JosephP]

@abousetta
don't see the need for assistance-you have linked to suitable help?

[abousetta]

Tried the solution but was giving me errors on my computer. Not sure if its because I am running windows? So I couldn't give a working solution to the OP.

[:) Sixthsense :)]

I am unable to continue the below thread since I don't find ample of time to go through each an every logic again and build it in UDF.

The below is the thread where the OP is waiting for the reply.
http://www.excelforum.com/excel-form...-book-2-a.html

In the final post of the above link OP included a file for UDF solution which was discussed here

I requested the OP to give some time for me for giving UDF solution, but OP is keep on sending Private Message and asking the status of the solution, which made to call all of your help.

[abousetta]

If the OP is giving you a hard time then clearly tell them that you will not be able to continue on the project. Create boundaries and stick to them. You don't have to answer any question you don't feel comfortable with. If they keep bugging you then request that one of the moderators intervene.

[martindwilson]

any one shed light on this?
http://www.excelforum.com/excel-form...-in-pairs.html

[:) Sixthsense :)]

@ abousetta,

Thanks for reminding me it's a project and for your valuable guidance

[tigeravatar]

I honestly have no idea what is being asked for here
http://www.excelforum.com/excel-prog...html?p=3042628

[alansidman]

http://www.excelforum.com/access-tab...-analysis.html

This is a request for help with tables in Excel. I have seen this before, but have no experience in how to do it. If you can help this OP, please do so. You may have missed this thread as it was posted in the Access forum. Have requested it be moved.

Also, if you have a tutorial on what he is looking for, I would be interested.

Alan

[TMS]

Anyone up for an intellectual challenge?

if or function


I have provided a working solution, however, it is neither elegant nor scaleable.

Anybody care to have a look and provide an alternative. I'm sure there must be one. I have a mental image of something with curly brackets. Be aware, there are basically two subsets, one with a range of values separated by "-" and another with less than or equals/greater than or equals. The range is fairly straightforward with MID and two FINDs. The other half is a string of SUBSTITUTES.

Got to be a better way.

Regards, TMS