Re: $$Excel-Macros$$ Concatenate after checking all cell

2009-12-17 Thread rf1234 rf1234
Dear paul Thanks For reply. I know concatenation =CONCATENATE(B2,C2,D2,E2,F2,G2) =(B2&""&C2&""&D2&""&E2&""&F2&""&G2) Will not give the suitable result As i have already tried.Prblem is that 6 person enter the data for same client and now i have to concatenate these report. As i mension in the ex

$$Excel-Macros$$ DATEDIF Is there a replacement available?

2009-12-17 Thread okey
It's undocumented. It's broken in 2007. Is there something else available? -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com

$$Excel-Macros$$ Macro to copy and clear range

2009-12-17 Thread Anthony
I am trying to copy a range of cells, paste the range of cells into the same worksheet, and then delete the values in some of the cells. The values in these cells will vary from week to week. The values in all the other cells are either data that will not change (names) or the result of formulas.

Re: $$Excel-Macros$$ Help Required in Excel Roster

2009-12-17 Thread Norman May
Hems, Basically there are hidden helper columns and rows that do some of the calculations. One of the hidden rows counts how many changes from Sunday to Monday. Then the OFFSET function was used to access this calculation that dictate the correct offset. A formula with several IF functions were us

Re: $$Excel-Macros$$ Help Required in Excel Roster

2009-12-17 Thread Hems
Norman, Dude its too gud Keep it up ... i wud lik learn all this ...how did u manage this?? Cheers! Hems On Thu, Dec 17, 2009 at 10:25 PM, Norman May wrote: > Hems, > > Attached is another version of your Roster. > > Norman > > On Tue, Dec 15, 2009 at 12:56 PM, Hems wrote: > >> Hello A

Re: $$Excel-Macros$$ Help Required in Excel Roster

2009-12-17 Thread Hems
Hey Norman, Amazing work... yup this is what i wanted ...appreciate if cud explain the logic ..in short.. Thanks a lot bro Cheers! Hems On Thu, Dec 17, 2009 at 6:26 AM, Norman May wrote: > Hopefully this is what you wanted. > > Norman > On Tue, Dec 15, 2009 at 12:56 PM, Hems wrote: > >>

Re: $$Excel-Macros$$ PIVOT TABLE AND PERCENTAGE

2009-12-17 Thread Skanda
Anish, Thanks for the quick turn around.Can you tell me how to get the solution.I have data that has 20,000 rows. Skanda. On Thu, Dec 17, 2009 at 2:28 AM, Anish Shrivastava wrote: > Hi Skanda, > > Attached please find the solution..Lemme know if the format is according to > your requirements.. >

Re: $$Excel-Macros$$ Concatenate after checking all cell

2009-12-17 Thread Paul Schreiner
Not sure of your meaning.. "concatenate" means to join two strings end-to-end. so, your first line becomes: 0-Jan-000-Jan-000-Jan-0029-Nov-080-Jan-000-Jan-00 THAT is the meaning of "concatenation". At first glance, it looks like you're trying to find the maximum (or latest) date. However, in your

$$Excel-Macros$$ Concatenate after checking all cell

2009-12-17 Thread shyam
Date at sheet1 Date at sheet2 Date at sheet3 Date at sheet4 Date at sheet5 Date at sheet6 Concatenate(Final po Date) 0-Jan-000-Jan-000-Jan-0029-Nov-08 0-Jan-00 0-Jan-0029-Nov-08 0-Jan-000-Jan-000-Jan-0029-Nov-08 0-Jan

$$Excel-Macros$$ Concatenating after checking cells

2009-12-17 Thread rf1234 rf1234
*Date at sheet1* *Date at sheet2* *Date at sheet3* *Date at sheet4* *Date at sheet5* *Date at sheet6* Concatenate(Final po Date) 0-Jan-00 0-Jan-00 0-Jan-00 29-Nov-08 0-Jan-00 0-Jan-00 29-Nov-08 0-Jan-00 0-Jan-00 0-Jan-00 29-Nov-08 0-Jan-00 0-Jan-00 29-Nov-08 0-Jan-00 0-J

Re: $$Excel-Macros$$ identifying duplicates

2009-12-17 Thread rf1234 rf1234
Option Explicit '''IN SHEET1 FROM C1 RANGE U CAN PUT THE VALUE DISTINCT VALUE CAN BE SEEN IN SHEET3 A1 RANGE ' ' Sub MergeDistinct()

Re: $$Excel-Macros$$ identifying duplicates

2009-12-17 Thread Swapnil Palande
Hi Steve, Please find attached excel for solution to your query. I have use conditional formatting to find duplicate values in the lists. Following is formula: =COUNTIF(D3:D18, B3)>=1 I have applied conditional formatting for list 1. If name is there in both the list then it will highlight that

Re: $$Excel-Macros$$ identifying duplicates

2009-12-17 Thread Anish Shrivastava
Hey Steve, Looks like your problem can be solved by using simple vlookup. Can you please provide an example sheet so that I can put in the solution... (Sorry, no time out of office work to create the example sheet myself) Cheers!! ANISH On Thu, Dec 17, 2009 at 1:14 PM, Steve wrote: > I have a

Re: $$Excel-Macros$$ Sorting Data

2009-12-17 Thread Paul Schreiner
Let me see if I understand. A7-A has information that will be untouched. First: the sort: the first 6 rows and 4 columns you want to sort. alphabetically. each cell? or each row? if each cell, vertically then horizontally? as in: Alpha Golf Mike Sierra Bravo hotel November Tango Charlie India 

Re: $$Excel-Macros$$ identifying duplicates

2009-12-17 Thread Paul Schreiner
If you're looking at an Excel function solution, it's fairly simple. I take it that you have the lists with columns like: LastName, FirstName, DOB ?? first of all, you need to "commonize" the list in some way. I would take the lists and add two columns. In one, insert the formula: =A1 & ", " & B1

$$Excel-Macros$$ identifying duplicates

2009-12-17 Thread Steve
I have a few lists of names and dobs, each over 1,000 lines. I am trying to find names and dob's that are common to two lists. The names I want to pull out are the ones that are on each, if they are only on one list I am not interested in them. What I've done so far is paste two lists together,

Re: $$Excel-Macros$$ SUMIF realted

2009-12-17 Thread Anish Shrivastava
hey Suhas, Could you please attach a sheet wid this example as it looks bit messed up here...data is not being displayed properly...once you send the sheet, will certainly give it a try.. ANISH On Wed, Dec 16, 2009 at 4:35 PM, Suhas wrote: > Hi everyone, > > I am facing some problems with SUMI

Re: $$Excel-Macros$$ PIVOT TABLE AND PERCENTAGE

2009-12-17 Thread Anish Shrivastava
Hi Skanda, Attached please find the solution..Lemme know if the format is according to your requirements.. Cheers!! ANISH On Wed, Dec 16, 2009 at 8:46 PM, Skanda wrote: > Srini, > Thanks for the response.Let me explain my requirement. > > We need the percentage at the physician level. > say f