Dear
one colum set structure :- month = jan-2008 jan-2009 jan-2010
then use use pivot table
On Sat, Oct 9, 2010 at 10:34 AM, Kal xcel wrote:
> Hi Worawat,
>
> Thanks for your advice. But I can't use pivot table in this scenario.
> Because lot of other issues attached with this.
>
> Thanks
>
>
Thanks Alpesh,
Got the file, checking.
Thanks once again
Kalyan
On Sat, Oct 9, 2010 at 10:38 AM, Kal xcel wrote:
> Hi Alpesh,
>
> please help me that how to get that file.
>
> Thanks
>
> Kalyan
>
> On Sat, Oct 9, 2010 at 6:57 AM, pesh wrote:
>
>> Kalyan,
>>
>> Please find the file: How+to+
Hi Alpesh,
please help me that how to get that file.
Thanks
Kalyan
On Sat, Oct 9, 2010 at 6:57 AM, pesh wrote:
> Kalyan,
>
> Please find the file: How+to+find+data+of+previous+month.xlsx uploaded
> to the Files section of this group.
> I believe it should meet your needs.
>
> Thanks.
> Alpesh
Hi Worawat,
Thanks for your advice. But I can't use pivot table in this scenario.
Because lot of other issues attached with this.
Thanks
Kalyan
On Sat, Oct 9, 2010 at 3:43 AM, worawat kh wrote:
> Hi Kalyan
>
> You can use pivot table to solve this ,
> better than use many excel function
>
>
>
Dear Ayush,
Thanks for you,
1) excel group
2) help all time
3) touch you every
4) help find job
you are great person in this world.
regard
Sumit Vyas
On Fri, Oct 8, 2010 at 9:20 PM, Ayush wrote:
> Dear Group,
>
> There is a opening for one person with the following skill to work as
> S
Kalyan,
Please find the file: How+to+find+data+of+previous+month.xlsx uploaded
to the Files section of this group.
I believe it should meet your needs.
Thanks.
Alpesh
On Oct 8, 4:38 am, Kal xcel wrote:
> Dear Experts,
>
> I want to extract last 3 months consolidated sale data based on current
>
Hi Kalyan
You can use pivot table to solve this ,
better than use many excel function
Worawat
2010/10/8, Kal xcel :
> Dear Experts,
>
> I want to extract last 3 months consolidated sale data based on current
> month.
>
> I have attached the file with my query.
>
> Thanks in advance
>
> Kalyan
>
Hi Guys,
So I a simple indirect function that looks into another file (the name
of which is in my sheet in cell I1) and find the value in cell A3 of
the sheet in that file called Output. This is that function:
=INDIRECT("["&$I$1&".xls]Output!A3")
However, when i drag this formula down the refere
Dear Carlo,
Select Range Q:R i.e. both entire col and vlookup is enough
Regards
Ramkesh
On Thu, Oct 7, 2010 at 5:48 PM, cg wrote:
> Hi everybody
> I’ve a big trouble but maybe, for you is an easy trouble.
>
> I’m working on excel2003.
> I’ve to compare two values, in the same pivot table, usin
hi sir,
i think you can't find solution that problem by excel..:)) (mmm...
maybe your finger can lose a little weight) but i can advice to you
zumba...:))
it will be more useful than excel.
ohh and i have a problem with my hair.. i am starting to lose it.. if
someone have any excel program.. abou
Dear Group,
There is a opening for one person with the following skill to work as
Sub contractor.
Basic Skill set: (Mandatory) Advance knowledge of xl and VBA Marco
Advance Skill Set: (Optional) Exposure to PM methodology & Quality
Systems
Qualifications: MCA/BE
Company Name :- STMicroelectroni
Hey Dude,
Do this,
Select the Cell which you want to delete and Ctrl+Select Every Sheet, then
press Delete.
I hope it will helpful.
Regards,
Krrish
On Fri, Oct 8, 2010 at 6:40 PM, sudheer lolla wrote:
> Hi guys
>
> I Have a column "xyz" which is there in every sheet of the workbook
> and th
Hi Excellers, I am having a problem, I am trying to lose some weight,
it is for tha reason that I would like to request anyone of you to
send me a template that I can use to check my weight, either in excel
of access format- diet tips could come in handy alongside that
template. Preferably the tips
Thank you
On Fri, Oct 8, 2010 at 6:07 PM, عمر wrote:
> See this
>
> http://www.youtube.com/watch?v=CrX6353lSx4
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Vishal Angre
> *Sent:* Friday, October 08, 2010 12:34 PM
> *To:* excel-macros
Hi Guys,
I am running a variance between two numbers and am unable to get the proper
condition required.
In the file attached in Clmn E it is working correct if there are numbers in
Clmn B. But if B is zero then the formula should show a red arrow (if there is
a number in Clmn A)
Hope someon
Hi guys
I Have a column "xyz" which is there in every sheet of the workbook
and the column number in sheet A is 1 ,sheet B is 2,sheet C is 1
If i delete a value from that column "xyz" in sheet A,the deleted cell has
to be deleted from these B,C sheets
But the vice-versa should not happen i.e Del
Dear Sumit
only 4 column(A,B,C,D) in atteched excel how to hide column E,F,H.
thank & regard
Vishal
On Fri, Oct 8, 2010 at 5:08 PM, SUMIT VYAS wrote:
> Dear Vishal
>
> This trick is VBA inst log file.
>
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Cells.Count = 1
See this
http://www.youtube.com/watch?v=CrX6353lSx4
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Vishal Angre
Sent: Friday, October 08, 2010 12:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Column hide from excel
4 column(
Dear Vishal
This trick is VBA inst log file.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count = 1 Then
If Target.Value <> "" Then
If Target.Column = 3 And Target.Row > 1 Then
Target(1, -1) = Format(Now, "dd-mmm- hh:mm:ss")
Target(1, 0) = Application.UserName
End If
E
4 column(A,B,C,D) in atteched excel, please tell me how to do this
--
With Regards,
*Vishal K. Angre*
E-mail : visha...@gmail.com
vishal.k.an...@gmail.com
--
--
Some important links for excel users:
1.
THANKS. BUT IT SERVE THE PURPOSE PARTIALLY...IN ADDITION I HAVE TO CONSIDER
ONLY FY 2009-10 WHEREAS FORMULA TAKES BEYOND 31/03/2010.3
IS IT POSSIBLE TO REVISE THE FORMULA.
REGARDS,
C.G.KUMAR
On Fri, Oct 8, 2010 at 2:19 PM, ashish koul wrote:
> check the atatchment see if it helps
>
>
>
> On
Hi,
I accidentally found an answer to the question put up by N Shivkumar. So
wanted to share the same, though I am sure most of you must have found the
solution to this. Following are the steps:
1) Select the column/cell where you want to have the format with the
new ` rupee
symbol.
2) Change the
Objective is to calculate Sale for the financial year 2009-10 (April 2009 -
March 2010 )for each staff no. Data are in sheet named 'DATA' in different
column. It Starts with Staff No. then Start Date, End Date, Sale Type, and
Amount (It is Sale per month during start and end period).
1. F
Dear All
Please help me on given problem
Problem
I have many sheet in File(more than 30)
In Shhet 1 ,C4 =B4
In Sheet 2 C4=B4 of sheet2 + C4 of sheet 1
If I copy paste this pformula in sheet 3 it will take as
C4= B4 of Sheet 3+C4 of sheet 1 but actually I want
C4= B4 of Sheet 3+C4 of shee
24 matches
Mail list logo
