Search results

Hello friends of chandoo.org & here's my Q. How do I clean up a list of names? Sometimes there is only one name, which I know how to fix. But sometimes there are multiple names. This is the recipient field from a long list of emails. Entries are in this form: Angie Klare...

Thanks again. Will try i & get back to u.

Many thanks bobodj....that was so quick.

Million thanks bobhc 4 the first VB solution. I am trying it out but i'm getting a "Expected End Sub" error. The second VB gives a list of 56 colours on worksheet1 where the macro is run. But how do i select any one colour in worksheet2 so that the borders of the active cell assume the...

Hello Friends. I have a list of names (Last Name, First Name). Is there a formula to flip them to First Name, Last Name? Regards, James

Hello guys & here's my Q. All of us like colours. So how can i make the borders of the "Active Cell" a different colour. Every time i click on a new worksheet i would like the borders of the active cell have a different color. For instance if i select worksheet1 the borders of the active...

Hello friends of Chandoo.org, I'm thinking of renting my car for the next several years and I am wondering what the cash flows will look like, (keeping in mind depreciation). Can someone here share a cash flow model in excel that they have developed, or seen on some website ? Thank u in...

Hello SirJB7. That was truly convincing! I am very impressed and very grateful 4 all that wonderful explanation. A million thanks 4 all the trouble taken in explaining all that 2 me. Long live CHANDOO.ORG Best wishes & stay blessed. James

Hello Narayan, There was so much clarity in ur explanation, that i enjoyed reading & learning from it. Best wishes, James

Hello friends of Chandoo.org & here's my question. Cells A1=9, A2=99, A3=999. Now i make cell J4=A1. So J4 returns the value 9. Perfect. Now Row 5 is 99% hidden; and naturally so is cell J5. So i would like cell J6 (instead of J5 which is hidden) to return the value of A2, which is 99, when...

Many thanks Narayan, & very well explained. Stay blessed. James.

Hello friends, Looking for a formula, which will give me SUM(Total) of the particular range. But here's the catch......I have data (figures/values) in %.

Hello friends, Is there a way to concatenate worksheets in different workbooks, into one worksheet in a new workbook? Best wishes, James

Hello friends, Is there a way to concatenate worksheets in different workbooks, into one worksheet in a new workbook? Best wishes, James

Hello Narayan....GOT IT!. Thanks 4 the Format Painter tip. After doing FP 4 each category i then did.....CF--> Manage Rules -->Edit Rule.....and i had2 only change the "values" 4 each category which r different, as u will c in my Q. Much appreciated. James

Hello Narayan.....the Format Painter doesn't solve the CF in other cells for Tech, Assembly & Packing, simply because the "Approved" values are different. Can u suggest another solution.... Thank u in advance.... James

Many thanks NARAYANK.....this may sound strange, but i am unable to locate the format painter on my Mac...... Typically, its on the Home group, but now its missing...???? Will find the missing FP and try out ur solution and let u know.

Hello all..... here's my problem. Personnel Approved Engaged On duty C/Staff 196 195 197 Tech 149 176 175 Assembly 415 403 90 Packing 59 59 197 I have done CF in col C2 using...

Many thanks sachinbizboy 4 ur time & solutions. And thank u Faseeh 4 ur solution & that very useful link. Here's my solution... Data->filter ->advanced filter-> select range , click on copy to another range, unique values only, and click on OK.

In column A i have 200 names of countries but some are repeated....Here r 2 Qs. 1. How do i count how many countries are there.???? (avoiding the repetition)....& 2. Is there a formula to give a "listing" of the name of those countries. Thank u in advance.

Hello greykitten...i've downloaded ur file & used PivotTables. It works great! Keep adding names & do a refresh. hth james

Hi all.... Looking4 a formula to determine month or year in a range of cells. A B C D E F G H I 1 SUN MON TUE WED THU FRI SAT YEAR MONTH 2...

Hello everybody.... I have 3 Columns. A-Approved, B-Engaged, C-OnDuty. I want 2use CF with icons for col B & col C. How2 copy the formatting to all 20 rows? Thank u in advance.

Hello Beroth, Your Q - is there a formula that functions as SUMIF but returns the MAX of the sum_range? Will the following formula serve ur purpose? =MAX(IF(A1:A9>5,A1:A9,"")) Best wishes.

Hello Beroth.....Pls try out the following formulas. Hope that helps. 1. =MAX(INDEX((A1:A25=D1)*B1:B25,)) 2. =LARGE(IF(A1:A25=D1,B1:B25),1)) All the best!