Hi,
i got it, in the tab home wrote:
> Hi,
>
> see the attachement for my prob., i made a drop down but after removing the
> list the symbol of dropdown list still is there, it is by default of any
> trick to remove, it is not coming in print but visible on screen
>
> please help
>
> Thanks & Reg
धन्यवाद
आप सब को भी मकर संक्रांति की शुभ कामनाये
विकास गुप्ता
On Fri, Jan 14, 2011 at 10:55 AM, Chandra Singh Bora wrote:
> * आपको *
> * और *
> * आपके *
> * परिवार *
> *
Dear Ashish,
I am unable to find data through Vlookup+indirect when sheet name is Date
wise like 14-Jan,15-Jan,16-Jan.
Please see attached sheet..
--
Thanks & regards,
Noorain Ansari
On Thu, Jan 13, 2011 at 9:49 PM, ashish koul wrote:
> hi
> 1 case sensitive lookup using index and match
I have a pivot table
how to use " Or" in two columns
I want to view all rows which
Column1 = "cat" Or column2 = "cat"
Not
Column1 = "cat" AND column2 = "cat"
By code or any way
Thanks!
--
--
Some
Hi,
see the attachement for my prob., i made a drop down but after removing the
list the symbol of dropdown list still is there, it is by default of any
trick to remove, it is not coming in print but visible on screen
please help
Thanks & Regards
ROHAN
9818247278, 8860567680
--
--
Dear Group Friends,
I have two work sheet. Sheet1 contain bill number in column B, and
sheet2 contain bill number and PRA No in column A and column B.
My problem is, I want to concatenate the PRA No. with "," for every
unique bill Number.
e.g. Sheet1 date are as Under:
Bill No.
FDN/01
FDN/02
FD
Thanks and Wish you* Happy Makar Sankranti* to u as well
Regards,
Manoj Kumar
On Fri, Jan 14, 2011 at 10:55 AM, Chandra Singh Bora wrote:
> * आपको *
> * और *
> * आपके *
> * परिवार *
> *
Congratulations Dilip... :)
Regds,
Manish Pansari
On Jan 5, 7:19 pm, Kal xcel wrote:
> Hi Dilip,
>
> Many many congratulation to you. This group needs you. Keep it up.
>
>
>
> On Wed, Jan 5, 2011 at 4:45 PM, SUMIT VYAS wrote:
> > Dear Mr. Dilip
>
> > *Congratulations to you*
>
> > Regards
>
> >
One of the function which I do like is "TRANSPOSE" function.
- This function copies data from a range, and places in it in a new range,
turning it so that the data originally in columns is now in rows, and the
data originally in rows is in columns.
- The transpose range must be the same size as t
Hi,
see attachment hope it may help
thanks & Regards
ROHAN
9818247278, 8860567680
On Thu, Jan 13, 2011 at 8:51 PM, ashish koul wrote:
> attachement missing
>
> On Thu, Jan 13, 2011 at 7:11 PM, mikeb wrote:
>
>> I would appreciate some help with the following. I am trying to use
>> two crit
hi
1 case sensitive lookup using index and match
2 vlookup & indirect function
Check the attachment. Given you the situations where I used them in the past
On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . wrote:
> Hi All,
>
> I suggest all of you don't say this function I like and then thi
try this
Sub test()
Dim i As Long
' change value of i as per your requirement
i = 2
Range(ActiveCell, ActiveCell.Offset(i, 200)).Copy
End Sub
On Thu, Jan 13, 2011 at 11:03 PM, iggy-mac wrote:
> Ashish,
>
> Thanks for your help, that works just fine.
>
> If I was to take that a step further,
See if this helps you out...
Regards,
Manoj Kumar
On Thu, Jan 13, 2011 at 8:58 PM, Dilip Pandey wrote:
> Hi Kalyan,
>
> Attached file has been solved per your requirement(s). :)
> Let me know if this works.
>
> Best Regards,
> DILIPandey
>
> On Thu, Jan 13, 2011 at 7:11 PM, Kal xcel wrote:
>
Hi,
Please see the attachment,
but ur requirement is not clear, u want result when ur value in alternative
order or both of the columns has serial order, hope it will meet with ur
requirement.
Thanks & Regards
ROHAN
9818247278, 8860567680
On Thu, Jan 13, 2011 at 4:43 PM, NOORAIN ANSARI wr
thanks again. Very helpful tips!
On Jan 12, 10:19 pm, Manoj kumar
wrote:
> Hello Guys,
>
> Fill Handle(the small black square on the bottom-right corner of a selected
> range of cells) is one of the best option to fill dates, in fact you can
> fill Days, Weekdays, Months and Years as well.
>
> *
Hi All,
>From My Side,
Best Formula is Match()
Regards,
Rajesh. Nair
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Li
Hi,
I have a very stupid question here. I am using Excel 2003. I don't
know why when I am trying to enter a function in the spreadsheet, the
remaining part will not show up.
For example, when I am trying to enter the function: concatenate. I
will write =conca And the remaining part will pop up.
Ashish,
Thanks for your help, that works just fine.
If I was to take that a step further, how would I amend the code so
that the copy range stepped 200 to the right, regardless of how many
rows I highlighted ie sometimes I'll copy one row, somestimes it may
be 2,3..4 rows.
I can do it one at a t
Hi All,
I suggest all of you don't say this function I like and then this one like
that. Just sharing the function name won't help others to gain some
knowledge. All the functions which is available in excel is having the same
set of qualities unless it is used in perfect combination.
So give b
Hi All,
from my side.
=INT()
On Jan 13, 2011 9:04pm, kiran Kancharla wrote:
Hi All,
from my side I am adding 2 formulas.
1.Index
2.Match
One of the best functions..
Please have a look on the Attachment..
Thanks & Regards,
Kiran
On Thu, Jan 13, 2011 at
try this
Range(ActiveCell, ActiveCell.Offset(0, 200)).Copy
On Thu, Jan 13, 2011 at 7:06 PM, iggy-mac wrote:
> Hello Group,
>
> Can anyone help me with this “simple” line of code. I need a line
> that will allow me to:
>
> Starting at the cell I’m in,
> Extend right for 200 cells
> Activate t
Hi Kalyan,
Attached file has been solved per your requirement(s). :)
Let me know if this works.
Best Regards,
DILIPandey
On Thu, Jan 13, 2011 at 7:11 PM, Kal xcel wrote:
> Dear experts,
>
> Please help me on my quary. I have date wise depot wise product wise sale
> amount. I need to extract s
attachement missing
On Thu, Jan 13, 2011 at 7:11 PM, mikeb wrote:
> I would appreciate some help with the following. I am trying to use
> two criteria and if they are true then count the occurrences of the
> work “TRUE” in a specified column, I have attached a sample worksheet
> using excel for
check the attachment see if it helps
On Thu, Jan 13, 2011 at 7:11 PM, Kal xcel wrote:
> Dear experts,
>
> Please help me on my quary. I have date wise depot wise product wise sale
> amount. I need to extract sale between two dates matching with other two
> criteria(Depot & Product). I have tried
Dear members,
We all come to know about many functions & their best uses.
Please keep sharing. Thanks.
Best Regards,
Ayush Jain
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks an
I would appreciate some help with the following. I am trying to use
two criteria and if they are true then count the occurrences of the
work “TRUE” in a specified column, I have attached a sample worksheet
using excel formulas; however I would not object to using VBA to
accomplish the task. I act
Dear experts,
Please help me on my quary. I have date wise depot wise product wise sale
amount. I need to extract sale between two dates matching with other two
criteria(Depot & Product). I have tried sumifs & sumproduct formula, but
result is not coming properly.
Please help
Thanks in advance
Hello Group,
Can anyone help me with this “simple” line of code. I need a line
that will allow me to:
Starting at the cell I’m in,
Extend right for 200 cells
Activate the cells & copy
I want to use easy code ie along the lines of
ActiveCell.Offset(0,200).Range.Select
Or
Range.ActiveCell.Offset
Thanks Ashish
Thanks Dave.
-
Manish
On Jan 13, 7:14 am, Dave Bonallack wrote:
> Hi Manish,
> Place this code in the appropriate VBA sheet window
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.Column = 2 Then Cells(Target.Row, 3).ClearContents
> End Sub
>
> Ho
Dear Anubhav,
Please see attachement..
Thanks,
Noorain Ansari
On Thu, Jan 13, 2011 at 1:45 AM, Anubhav Somani wrote:
> Dear All,
>
> I have data for two years arranged in 2 columns respectively.
> Example.
>
> *Yr1*
>
> *Yr 2*
>
> A
>
> A
>
> B
>
> B
>
> C
>
> C
>
> D
>
> D
>
>
>
> F
>
>
>
>
Dear All,
I have data for two years arranged in 2 columns respectively.
Example.
*Yr1*
*Yr 2*
A
A
B
B
C
C
D
D
F
H
I
Now i want is to make a combined list (lets say in column 3) but there
should be no repetitions in this list (as in the above example, after
combining, i should o
Dear Group,
I want to know about how could link more excel sheet in one file without
hypper link. Please explain have tools in excel.
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
--
--
Some important links for
32 matches
Mail list logo