Dear Vebhav,
Please see attachment with solution.
Thank,s
Noorain
On Thu, Aug 26, 2010 at 9:39 AM, vebhav jain wrote:
> Hi All,
>
> Please find the attachment, where i finding the difficulty to get the right
> solution.I have narrated the problem clearly in the excel file.
>
> Thankyou,
> Vebhav
Dear Vebhav,
Your problem is solved, see the attachment.
Kalyan
On Thu, Aug 26, 2010 at 9:39 AM, vebhav jain wrote:
> Hi All,
>
> Please find the attachment, where i finding the difficulty to get the right
> solution.I have narrated the problem clearly in the excel file.
>
> Thankyou,
> Vebhav
Hi Venkat,
I was wondering if you could do away with simple sort command.
Given below is the result i got after sorting the provided data.
Emp id Product
C1101 A
C1104 A
C1107 A
C1110 A
C1113 A
C1116 A
C1119 A
C1102 B
C1105 B
C1108 B
C B
C1114 B
C1117 B
C1120 B
C1
Hi All,
Please find the attachment, where i finding the difficulty to get the right
solution.I have narrated the problem clearly in the excel file.
Thankyou,
Vebhav Jain
--
--
Some important links for excel users:
1
If you mean with TextBox
please see workbook at
http://www.box.net/shared/nh5zl1vvhh
Regards,
siti
On 25 Agu, 17:39, Steen wrote:
> Hi
> i'll try to tell whta i'm trying to at what my problem is hope that
> you understand what i'm trying to do.
> i have made Work break sturcture, which describ
Hi,
why not using Keyboar-ShortCut:
Ctrl + PgUp and Ctrl+PgDown
Regards,
siti
On 23 Agu, 21:21, shariqcoo...@gmail.com wrote:
> Hi,
> Can any one tell me how we can link the macro code to hyperlink.
> I want to navigate the sheet by click the next or previous by using
> Activesheet.next.sel
Thanks in advance!
1. I am using MS Excell 2007
2. Problem: I have a Column of serial #'s and they are listed low to
high. Some of the Serial # are listed once, some twice and some 3
times.
3. I want to alternate shading for each set of the same serial #'s.
EX:
276CHK0130
276CHK0130
276CHK0131
27
I've been using Google Docs with the importXML function to pull
information off many external XML feeds at the same time. This has
been very useful but I'm starting to have a lot of trouble,
specifically in that Google Docs is limited to only 50 such functions
on any given spreadsheet, and I need s
I have 4 worksheets (WS1, WS2, etc.) with cells that get populated
with data from a linked source sheet. In Column B on each worksheet is
a dynamic range of cells (on WS1 it's "WS1Data," WS2 it's "WS2Data,"
etc.) When rows in the range are blank, I'd like to insert the word
"no data."
I can do thi
Hi! Shine,
Pls. find the attached file. This is also one of the way to solve your query
by using V LOOKUP.
Regards,
Maries
On Mon, Aug 23, 2010 at 5:32 PM, wrote:
> Attached: Lookup Multiple values and display horizontally
> Message from shin...@gmail.com:
>
> Hi
>
> It would be helpful if s
Dear Kalyan,
My Correct Requirement Is Attached below
On Wed, Aug 25, 2010 at 4:30 PM, Kal xcel wrote:
> Hi venkat,
>
> VLOOKUP formula will solveyour problem, see the attachment.
>
> On Wed, Aug 25, 2010 at 3:15 PM, Venkatesan c wrote:
>
>> Dear Group,
>>
>> I have attached sample data belo
Hi venkat,
VLOOKUP formula will solveyour problem, see the attachment.
On Wed, Aug 25, 2010 at 3:15 PM, Venkatesan c wrote:
> Dear Group,
>
> I have attached sample data below i want to get defined criteria Emp id's.
> Can i have any formula's or Macros
>
> Best Regards,
> *
>
> Venkat
> *
>
Dear Jay,
Problem is solved. See the attachment.
On Wed, Aug 25, 2010 at 2:26 PM, lucky singh wrote:
>
> Hi,
>
> Need help in formula...
>
> I just need the only the first name to be extracted without space or gap...
>
> Regards,
> Jay S
> 8108932708
>
> --
>
> -
Jay
Try putting the following formula in cell C3:
=LEFT(B3,FIND(" ",B3,1))
Norman
On Wed, Aug 25, 2010 at 4:56 AM, lucky singh wrote:
>
> Hi,
>
> Need help in formula...
>
> I just need the only the first name to be extracted without space or gap...
>
> Regards,
> Jay S
> 8108932708
>
> --
>
> -
Hi
i'll try to tell whta i'm trying to at what my problem is hope that
you understand what i'm trying to do.
i have made Work break sturcture, which describes some given taks
FX
Taks Start dateend date
design12-aug-2010 20-sep-2010
these information i would lik
Dear Lucky,
Please find attachement with solution.
Thanks,
Noorain Ansari
On Wed, Aug 25, 2010 at 2:26 PM, lucky singh wrote:
>
> Hi,
>
> Need help in formula...
>
> I just need the only the first name to be extracted without space or gap...
>
> Regards,
> Jay S
> 8108932708
>
> --
>
> ---
Hi Excel Gurus,
I have been working with excel,VBA, C++ for 2 years. lately I have come
across this task where I need to download this excel sheet from web page. I
have no idea how to automate the downloading .Can some gurus give some tips
and help? any advice is welcome.
The web page
Dear Group,
I have attached sample data below i want to get defined criteria Emp id's.
Can i have any formula's or Macros
Best Regards,
*
Venkat
*
--
--
Some important links for excel users:
1. Follow us on TWITTE
Hi,
Need help in formula...
I just need the only the first name to be extracted without space or gap...
Regards,
Jay S
8108932708
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Alternate proposal
Instead of creating the links in each sheet dynamically,
I think it is easy to create a customised toolbar with two buttons for
your purpose,
which can be used on any sheet, that is active.
Regards,
Kishan Reddy, K
On Aug 23, 7:21 pm, shariqcoo...@gmail.com wrote:
> Hi,
>
> C
20 matches
Mail list logo