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
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
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.
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
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
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:
>
>>
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..
>
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
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
*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
Option Explicit
'''IN SHEET1 FROM C1 RANGE U CAN PUT THE VALUE
DISTINCT VALUE CAN BE SEEN IN SHEET3 A1 RANGE
'
'
Sub MergeDistinct()
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
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
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
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
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,
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
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
18 matches
Mail list logo