Recent content by jasonleewkd

Thanks Hui, that works. One question, how do I skip rows 15 and 19? There's an Excel =AND formula but VBA's syntax is a little different.

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...

Congratulations Hui!

Awesome lifesaver!

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...

Closed

It's returning a nil value now. Is there a formula that will return the value in C12 dynamically based on the values in both I2:Y2 for a specified value between G3:G6?

Hi Suresh, is there a dynamic formula so that when I drag it to the right it will auto fill?

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!

I'm so sorry, here's the data presented properly Year Month Quarter Project Name Street Name Developer Property Type Locality Total Number of Units in Project Cumulative Units Launched to-date Cumulative Units Sold to-date Cumulative Units Launched but Unsold Units Launched in the Month Fresh...

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...

Thanks Suresh, how forgetful that there is delimiter that I could use! However, I would like to learn how to get A1 = 1600 to 1700 B1 = 1600 C1 = 1700 using a formula too please if possible :)

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...