Search results

I don't think we can "quantify" everything. What we provide is a service, not a product. And that's why we have to actively collect customer feedback, just like any other service oriented businesses, to prove the service we provide is a higher quality than the customers' previous experience...

Saving time and being transparent are very good but may not be the only value added function excel users can bring to the table. Once a new process is set up and workers are trained (I personally developed a reporting process using excel and reduce turnaround time but a day or two), there is no...

is 6/12/2012 your lookup value? from your sample provided, 1 in column D will not be pulled. you can also extract a lot of data using pivot table or filter. looks to me that you are asking for a filter?

basically randbetween(15,100) will give you a random integer.

Oh boy! I have sensitive data on my excel files and despite being password protected, others still have a way of cracking my passwords? That worries me a lot (fainting)!

Hi, 1. could you please kindly upload a sample file to look at? 2. you can draw some insight from what SirJB7 has helped me. I think it is very similar (not 100% identical though) in what we are asking. http://chandoo.org/forums/topic/how-to-write-a-macro-to-print-data-pertaining-to-a-list-box

Sorry I was late. I won't repeat others' comments. They are all true. Great job! Question: Cells J11, N11 and Q11. do you really want to show the month and not the % difference? It is not quite consistent in apprearance. For that reason, i am not sure if your formulae from J7:J11...

Couldn't go to main page. is it still down?

May be if you can tell us what these "ID", "%" mean in real life, then we may have a better idea of what you are trying to present. it's dummy data anyway. so your secret is safe. :)

in column A, make a filter. then filter to select to show only "Blank" cell in column A. "Go to special" select "visible cells". hi-light the rows. right click, select "delete row". Go back to filter, "select all". Wah-la! all empty rows are gone.

I thought about that, too. it will certainly work. what really bugs me is that I can do this with Excel 2003. for some strange reason this won't work in 2007 or 2010. Any way, thanks, Hui!

Hi I have 3 columns of raw data (a few thousand lines) column A: Customer Numbers (one number to one specific customer) column B: Customer Names column C: Sales figures A customer in any given month can have multiple differetn sales figures (multiple deals). So in column A customer 1234...

She wasn't even my boss. She's the only female manager in the region and one of the 26 managers I used to support by providing periodic/analytical reports. ;)

Totally agree with Hui,Greg and all. I used to be pigeon holed into a job role until i convinced my boss on paying for my first indepth 2-day excel class. from there i continue to explore and learn on the job. I used excel to demonstrate what it can do and consolidated 5 separate reports...

Thanks, Luke. you have brought out a great point. Yeah, I do realize that how we treat 1/1/2012 would make a big difference. I found out on Excel that January 1, 2011 (not 2012) is week 1 but Jan 2, 2011 is week 2. That said, some manufacturing plants would start their fiscal years on a...

Thanks Montrey. I know I can do that which I'd consider as a "long form" type of solution. I was just thinking using the year, the weekday and the week number to deduce the exact date. don't worry about it. i guess there is no short form solution. I was just trying to test my mind and...

don't mix up with the data and the formula. the middle number is the data in column B and the formula on the right is on column C.

let's say your days are on column A down and data on column B down. Then all you need A B C Date Data sum of last 3 value 1 67 2 85 3 40 =SUM(B2:B4) 4 62 =SUM(B3:B5) 5 49 =SUM(B4:B6) 6 56 =SUM(B5:B7) 7 80...

Can you show a sample please?

Can you show a sample please?

My boss popped a question and ask me for the dates of Friday on the 33rd week and the 49th week in 2012. I browse around the blog but all subjects were on dates converting into something else. You know, we start with a date then fidn out the week number or weekday using weeknum() and...

it is possible to have cell containing empty space but looks like blank cell. you can try your formula like this. In B2, hit the F2 key. See where the cursor is. if it doesn't look like resting on the far left of the cell, that means someone has hit the space bar once more multiple times in...

vijay.vizzu do you mean that if you add rows between A3:G6, then formulae on row 7 will break away from anything on row2? or do you mean if you insert rows 3 to 6 all formulae from row 2 to row 7 would fill in automatically so that you don't have to hi-light row 2 and and copy them down to...

Care to upload a file to see for ourselves?

you will probably need 2 drop down list, if i understand you correctly. see this for idea...http://chandoo.org/forums/topic/dependent-drop-down-lists