Search results

Forgot to mention that i cannot use pivot table. thanks

Dear all, I have a flat database which look like this: Area ID_Code Income Newyork A 500 Manhattan A 1000 Newyork B 250 How can i make another table which sum the income base on ID_code? The new table should look like Area A B Newyork 500 250 Manhattan 1000...

It works for me. Select use a formula to determine which cells to format. Then write : =C3="Job" Click Format and choose your desired formatting. Regards

Hi, can't you just add what bobhc suggested in VBA? .... For i = 1 to 100 if len(Cells(i,1).value) = 0 then cells(i,2).value = "No Account Number" endif next i ...... you can also use other method such as cells(i,1).value = "" or ISNULL, ISEMPTY regards

Hi charl. I think you should upload your workbook. Regards

Hm.. can you just filter it for blank cell in Column A and then Select Column B untill the last row then type "No Account Number" then press CTRL+ENTER (not just ENTER)

Hi, very sorry for the late reply. Faseeh, as I mention above, your formula works great. I did make a mistake, I should add OR in the IF part, not AND. I think I will use your solution, yet, I still looking for a way to know when to stop copying the formula in VBA. I think it should stop when...

Hi kaushiks03 and faseeh. Well the rule is to get the row number whenever there is update in name OR address. Still working on faseeh solution, but thanks in advance. Btw, the data that I have to retrieve is in Hundreds of files. So, I like to do some VBA processing. But if faseeh formula works...

Dear all, I'm trying to find a way to copy data based on non blank cells in certain columns the data is like this: A__B_______C_______D__________E No OldName NewName OldAddress NewAddress 1__David.._......_Dakota...._Chicago 2__Michael_.......LA...

Hi Supriya I am using office 2010 and it works just fine

SOLVED (I think..) I got it to work by using * and put the condition in bracket. I guess the missing piece was the bracket. Dear all, I have a problem which is similar to http://chandoo.org/forums/topic/lookup-top-10-values-in-a-table-with-conditions. My question is how do you do it for...

Hi everyone, I work as Data Processing/Analyst in the Ministry of Education (Indonesia). I used excel everyday so this site becomes my daily stop at work and this is where I found so many function that have been eager to find out.

Hi SirJB7, Sorry for the late reply.. Thanks for the info. I'll try your suggestion.

Hi Everybody, I hope that it is okay to ask it here. I am trying to create a simple system where I can get data from my associate through email (that goes in outlook) and process it with VBA. The only problem is that i can sent a reply email using VBA but i also want to send a confirmation...

Hi, I've download your workbook and made some adjustment to Narayank991 post =LARGE(IF($D$4:$D$16="yes";$C$4:$C$16;"");H4) as array formula in D36 (last table) and =INDEX($B$4:$B$16;MATCH(J4;$C$4:$C$16;0)) in C36 and copy it downwards.