Search results

Hi all, this must be a really easy question but I'm just getting started with VBA, and coding in general. I wrote a short macro to perform multiple goal seeks and the below is what I got. Now I'm sure the code can be shortened to a few lines by assigning some variables and looping, and I think...

Hi folks, I've got a sheet with semi-structured data. This current table can't be pivoted. I'm trying to 'transpose' the data into a table that can be pivoted. That will require a lot of manual work as I've got 276 headers and about 20 data points per header. I did some courses on VBA but this...

Hi all, is there no VBA code to do the above? MSDN help says to use SolverGet but it does not seem to work. Similarly, when I record a macro and run solver, the part where I untick the checkbox does not seem to appear? Anyone got any tips on this? The excel file is at the link and the...

Hi all, the chart looks deceptively easy to create, but I can't seem to do it. Tried things like format axis, gaps between axis, overlaps between charts but to no avail. Any form of help is appreciated! The link to the chart is here...

Hi all, I would love for some assistance. I'm not sure if vba must be required or a bunch of formulas is required. This really escapes me so I have no leads. Unlike my usual self which I'll investigate thoroughly. File can be found here http://bit.ly/14aSG9A. Thank you all!

hi all, it takes about 20 secs to recalculate this bunch of data when I turn on/off the filters. Is there a faster formula to do this? Probably an array i suppose? The formula in Column 'Fresh launch' reads =IF(AND(J2=M2,M2>0),"Yes","No") ' Year Month Quarter Project Name Street Name...

Hi experts, I'd like to extract numbers from these cells. I've searched online but i don't find any guide that tells me how to extract numbers when they are separated by a word. Appreciate any help. Thank you 1600 to 1700 400 to 500 900 to 1000 1500 to 1600 1500 to 1600 1300 to 1400 1200...

Hi Chandoo experts, I would like to seek help on the above. Let me explain in Sheet 2, A2 has the text "A.C.T Holdings..." in Sheet 1, A1:BBO134 has a whole bunch of data including "A.C.T Holdings..." in cell EN116; EN1 has text in it "bidder 4" What I need Sheet 2, cell B2 to return is...

Hi all, Could anyone help me with a formula that returns "JV" (when there is the word "And" in the referenced cell) or "Non-JV" (when there is no "And") "F.E.Lakeside Pte. Ltd., Fcl Topaz Pte. Ltd. And Sekisui House, Ltd. " JV Mcl Land Limited Non-JV The formula I came up with in B1...

Hi all, as above. Pivot table allows "Show values as... % of.. % of parent row total.. % of grand total" etc etc. For my situation however, none of the excel pivot defined functions work. Anyone has any idea insight on whether pivot table has such a function or vba needs to be used? The...

Hi gurus at Chandoo. Can anyone help me with the dataset I have and the retrieval? I have used formulas large, index & match, but not vba as I'm not well-versed in it. On the Y axis are nationalities. On the X axis are residential districts. The number in the body of the data is the...