Hi,
I need help with formula to calculate week on week and year on year
changes. for example the data is
Year 8-Sep 15-Sep 22-Sep
29-Sep
2009165.60 167.80 170.80
2010174.80 174.50 174.90
Every week one data
Hello,
I am enclosing a file <>. In this there are two tables. Table 1 is
the data table with rows and columns. Table 2 is the table in which i am
requesting your help in writing the formula to populate column F with data
from table 1. Formula in excel rather than VB will be helpful. thank you.
r
Hi
I have a data in cells and i want to reformat it with every alternate
cell as empty cell in excel.
so without any data loss every alternate cell will be empty.
please give me the solution.
Thanks
--
--
Some impo
=IF(A30="","",SUM(C3:C25)*ROUNDUP(Worksheet2!G3/G1,0))
I only need to Sum (C3:C25) ONCE, Then after that, Sum (C3:C10) for
the remaining.
Example: If G3 lets say is 100 and G1 is lets say 25 then Sum C3:C25
only ONCE then Sum C3:C10 for the remaining count which is 75 in this
example.
C3:C25
rds - Dave.
> Date: Tue, 3 May 2011 14:13:26 -0700
> Subject: $$Excel-Macros$$ Help with formula
> From: hemantda...@yahoo.com
> To: excel-macros@googlegroups.com
>
> Hi
>
> I have a data in cells and i want to reformat it with every alternate
> cell as empty cell in
Please attached Some Data with More Specification..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bob
Sent: Sunday, July 10, 2011 6:28 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help with formula
=IF(A30="",&qu
August 19, 2011 11:53 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help with Formula
Hi,
Can some one help me to create a formula in excel. Using the attached file,
please refer to the "Monthly IS" tab, column D. I need help writing a formula
that will:
1.. retr
Hello
I have many cells with formulae in them in Sheet "Main"
For Example:
='Staff Bonus'!E67
Is there a simpler way to go to the Sheet "Staff Bonus" and cell "E67"
from the "Main" sheet which contains this formulae?
I think I was able to do this much earlier, but either I am mistaken or
Hello,
I am enclosing file <>. I need help in populating the report
table (Table 2). Problem explained in detail in the file. thank you
regards
Harris
--~--~-~--~~~---~--~~
--
Some imp
Can you mail the sheet password back ?
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Bob
Envoyé : dimanche 10 juillet 2011 20:57
À : excel-macros@googlegroups.com
Objet : Re: RE: $$Excel-Macros$$ Help with formula
Here is the file. On the Quote
=HYPERLINK("#'"&SUBSTITUTE(CELL("address",Sheet2!A3),"!","'!"),Sheet2!A3)
On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan wrote:
>
> Hello
>
> I have many cells with formulae in them in Sheet "Main"
>
> For Example:
>
> ='Staff Bonus'!E67
>
> Is there a simpler way to go to the Sheet "Staff Bon
=HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1)
Regards
Sam Mathai Chacko
On Mon, Aug 6, 2012 at 9:41 PM, ashish koul wrote:
> =HYPERLINK("#'"&SUBSTITUTE(CELL("address",Sheet2!A3),"!","'!"),Sheet2!A3)
>
>
>
>
> On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan wrote:
>
>>
>> Hello
>>
>> I hav
Try CTRL+[ ] from formula cell
CA Kantilal Badale
E-Hall, First Floor,
B. J. Market,
Jalgaon.(Maharashtra)
9822250393
On Mon, Aug 6, 2012 at 10:08 PM, Sam Mathai Chacko wrote:
> =HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1)
>
> Regards
>
> Sam Mathai Chacko
>
>
> On Mon, Aug 6, 2012 at
r(.Formula, "!") + 1, 256)
Application.Goto reference:=Sheets(ms).Range(mc)
End With
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Kantilal Badale
Sent: Tuesday, August 07, 2012 12:26 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Exce
Dear Kantilal, Sam & Ashish
All your options work and are helpful. Appreciate your help and thanks a
lot (Couldn't respond earlier as I was away)
Thanks
Ashish Pradhan
On 07-08-2012 10:56, Kantilal Badale wrote:
Try CTRL+[ ] from formula cell
CA Kantilal Badale
E-Hall, First Floor,
B. J. M
Thanks Sam , it is useful for me also.
prince
On Monday, August 6, 2012 10:08:09 PM UTC+5:30, Sam Mathai Chacko wrote:
>
> =HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1)
>
> Regards
>
> Sam Mathai Chacko
>
> On Mon, Aug 6, 2012 at 9:41 PM, ashish koul
> > wrote:
>
>> =HYPERLINK("#'"&SUBSTITU
Hi Ravinder,
thanks a lot, yes this is very helpful. exactly what i needed . :)
Thanks and Regards,
Gargee Singh
From: ravinderexcelgr...@gmail.com
To: excel-macros@googlegroups.com
CC: quote.ex...@gmail.com
Subject: RE: $$Excel-Macros$$ Help with formula in vba
Date: Sat, 7 Dec 2013 12
x27;C:\Users\User\Desktop\Reports\[Reason
Codes.xlsx]Rail'!$A$1:$B$62,2,FALSE))"
Thanks and Regards,
Gargee Singh
From: garge...@hotmail.com
To: excel-macros@googlegroups.com
CC: quote.ex...@gmail.com
Subject: RE: $$Excel-Macros$$ Help with formula in vba
Date: Sat, 7 Dec 2013 15
oops sorry, 291log
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871
19 matches
Mail list logo