subject:"RE\: $$Excel\-Macros$$ Excel formula help"

Re: $$Excel-Macros$$ Excel Formula - Help needed

2018-06-18 Thread ankur

hi  Kaushik
use this one

=IF(C3>=VLOOKUP(D3,$F$13:$G$16,2,0),"yes","no")

excel sheet is attached for your reference





*With Regards:*

 *CMA** Ankur Pandey*
  *B.Com (H), C.M.A *
*  Mob: :- +919532513513*


*P* Please don't print this e-mail unless you really need it.

"This e-mail message may contain confidential, proprietary or legally
privileged information intended solely for the use of the addressee(s). If
you are not the intended recipient, please notify the sender by e-mail and
delete the original message. Further, you are not to copy, disclose, or
distribute this e-mail or its contents either partly or completely. Before
opening any attachments please check them for viruses and defects."


On Sat, May 26, 2018 at 2:00 PM, Rabindra Thapa 
wrote:

> hope this attached fulfill your requirement.
>
> *Regards,*
>
>
>
> *For quick responds click here for Message *
>
> On Sun, May 13, 2018 at 6:16 AM, KAUSHIK SAVLA 
> wrote:
>
>> Hi All,
>>
>> Attached is the excel file which I am referring for help.
>>
>> Background: Daily basis there are some transactions getting created and
>> are either approved or pending or rejected. For the one's which are pending
>> we want to build a tracker which once data is dumped it will show whether
>> follow up needed or not basis some criteria.
>>
>> Details:-
>> 1. The criteria is as below:-
>> If cell in Column D has "Mr A" then after 3 business days followup need
>> to be done, if "Mr B" then after 2 days follow up need to be done, if "Mr
>> C" there then after 1 day follow up need to be done, if "Mr D" then 2 days
>> after which follow up need to be done
>> 2. Column C contains formula which shows from current date how many days
>> the transaction is sitting for approval. Problem here is it is taking into
>> account all days but I want only business days which should exclude
>> weekends ie. Saturday and Sunday
>> 3. I want formula to give the same result as shown in Column E.
>>
>> Please do the needful.
>>
>> Regards,
>> Kaushik Savla
>>
>>
>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may

Re: $$Excel-Macros$$ Excel Formula - Help needed

2018-05-26 Thread Rabindra Thapa

hope this attached fulfill your requirement.

*Regards,*



*For quick responds click here for Message *

On Sun, May 13, 2018 at 6:16 AM, KAUSHIK SAVLA 
wrote:

> Hi All,
>
> Attached is the excel file which I am referring for help.
>
> Background: Daily basis there are some transactions getting created and
> are either approved or pending or rejected. For the one's which are pending
> we want to build a tracker which once data is dumped it will show whether
> follow up needed or not basis some criteria.
>
> Details:-
> 1. The criteria is as below:-
> If cell in Column D has "Mr A" then after 3 business days followup need to
> be done, if "Mr B" then after 2 days follow up need to be done, if "Mr C"
> there then after 1 day follow up need to be done, if "Mr D" then 2 days
> after which follow up need to be done
> 2. Column C contains formula which shows from current date how many days
> the transaction is sitting for approval. Problem here is it is taking into
> account all days but I want only business days which should exclude
> weekends ie. Saturday and Sunday
> 3. I want formula to give the same result as shown in Column E.
>
> Please do the needful.
>
> Regards,
> Kaushik Savla
>
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Excel Formula.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Excel formula help need

2014-04-29 Thread Paul Schreiner

??
That's what sorting does.
 
evidently, you have additional requirements that you've not included.

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-



 From: Shrinivas Shevde shrinivas...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Tuesday, April 29, 2014 6:41 AM
Subject: $$Excel-Macros$$ Excel formula help need
  


Please find attacehd Sheet

-- 
Shrini 
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an 
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.




-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Excel formula help need

2014-04-29 Thread Dileep Kumar

Dear Shrinivas,

Try using Select Visible Cells in customizng Quick Access Toolbar (QAB)
activate it select multipul cells and click on Select Visible Cells button
and then copy and past.

Please revert if it don't work.


On Tue, Apr 29, 2014 at 4:51 PM, Paul Schreiner schreiner_p...@att.netwrote:

 ??
 That's what sorting does.

 evidently, you have additional requirements that you've not included.

 *Paul*
 -







 *“Do all the good you can,By all the means you can,In all the ways you
 can,In all the places you can,At all the times you can,To all the people
 you can,As long as ever you can.” - John Wesley*
 -

*From:* Shrinivas Shevde shrinivas...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Tuesday, April 29, 2014 6:41 AM
 *Subject:* $$Excel-Macros$$ Excel formula help need

 Please find attacehd Sheet

 --
 Shrini
 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


--
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.




-- 
Regards,
Dileep Kumar Kaza

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-24 Thread respuzy

Thanks Kris for the quick reply
A little bug in the formula
If you include the named range matchcol in the formula. The figures don't 
update when you select another year.  
Sent from my BlackBerry® smartphone from Airtel Ghana

-Original Message-
From: Kris krishnak...@gmail.com
Date: Fri, 23 Mar 2012 21:50:49 
To: excel-macros@googlegroups.com
Cc: resp...@gmail.com
Subject: Re: $$Excel-Macros$$ Excel formula help needed

Hi

In B3 on Sheet1

=IFERROR(MATCH('PL 
(2)'!$H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0),2)

Define B3 '*MatchCol'*
*
*
Now in B12 and copy down  across,

=IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MatchCol+COLUMNS($B12:B12)-1),)

Kris

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-24 Thread Kris

It does. Set your calculation to automatic.

Kris

On Saturday, 24 March 2012 12:43:42 UTC+5:30, hilary lomotey wrote:

 Thanks Kris for the quick reply
 A little bug in the formula
 If you include the named range matchcol in the formula. The figures don't 
 update when you select another year. 
 Sent from my BlackBerry® smartphone from Airtel Ghana
 --
 *From: * Kris krishnak...@gmail.com 
 *Date: *Fri, 23 Mar 2012 21:50:49 -0700 (PDT)
 *To: *excel-macros@googlegroups.com
 *Cc: *resp...@gmail.com
 *Subject: *Re: $$Excel-Macros$$ Excel formula help needed

 Hi

 In B3 on Sheet1

 =IFERROR(MATCH('PL 
 (2)'!$H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0),2)

 Define B3 '*MatchCol'*
 *
 *
 Now in B12 and copy down  across,


 =IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MatchCol+COLUMNS($B12:B12)-1),)

 Kris



-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-24 Thread respuzy

Hi Kris

Kindly select start year as 2012 or 2013. You will realize that these two yrs 
do not hv any data but if you select them its populates the data from 2006 
onward instead of blank. 
Sent from my BlackBerry® smartphone from Airtel Ghana

-Original Message-
From: Kris krishnak...@gmail.com
Date: Sat, 24 Mar 2012 00:56:33 
To: excel-macros@googlegroups.com
Cc: Kriskrishnak...@gmail.com; resp...@gmail.com
Subject: Re: $$Excel-Macros$$ Excel formula help needed

PFA

Kris

On Saturday, 24 March 2012 12:51:10 UTC+5:30, Kris wrote:

 It does. Set your calculation to automatic.

 Kris

 On Saturday, 24 March 2012 12:43:42 UTC+5:30, hilary lomotey wrote:

 Thanks Kris for the quick reply
 A little bug in the formula
 If you include the named range matchcol in the formula. The figures don't 
 update when you select another year. 
 Sent from my BlackBerry® smartphone from Airtel Ghana
 --
 *From: * Kris krishnak...@gmail.com 
 *Date: *Fri, 23 Mar 2012 21:50:49 -0700 (PDT)
 *To: *excel-macros@googlegroups.com
 *Cc: *resp...@gmail.com
 *Subject: *Re: $$Excel-Macros$$ Excel formula help needed

 Hi

 In B3 on Sheet1

 =IFERROR(MATCH('PL 
 (2)'!$H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0),2)

 Define B3 '*MatchCol'*
 *
 *
 Now in B12 and copy down  across,

 =IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MatchCol+COLUMNS($B12:B12)-1),)

 Kris

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-24 Thread Kris

OK

Replace the B3 formula on sheet1 with

=IF('PL (2)'!$H$4=ALL Year,2,MATCH('PL 
(2)'!$H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0))

and in b12 and copy down  across

=IF(ISNUMBER(MatchCol),IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MatchCol+COLUMNS($B12:B12)-1),),)

Kris

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-23 Thread hilary lomotey

Hi Maries

The formula works perfectly for SIC, however for GCB and GGBL, it seems to
pick the same figures for all the years. with FML , its picking the an
incorrect figures.

kindly verify for me. thanks

On Thu, Mar 22, 2012 at 8:30 PM, Maries talk2mar...@gmail.com wrote:

 GCB  GGBL Error Rectified. PFA latest.


 On Thu, Mar 22, 2012 at 11:11 PM, hilary lomotey resp...@gmail.comwrote:

 genius Maries

 Great solution. works to perfection.  thanks boss

 On Thu, Mar 22, 2012 at 3:56 PM, Maries talk2mar...@gmail.com wrote:

 HI,

 Please find the attached file of Revised one. Ignore Previous one.

 Regards,

 MARIES.


 On Thu, Mar 22, 2012 at 7:07 PM, Maries talk2mar...@gmail.com wrote:

 Hi,

 PFA.

 =IF(B11=,,CHOOSE(Sheet1!$B$2,FML!B5,SIC!B5,GCB!B5,GGBL!B5))

 Regards,

 MARIES



 On Thu, Mar 22, 2012 at 6:00 PM, hilary lomotey resp...@gmail.comwrote:

 PERFECT, exactly what i needed. tx so much.

 sorry i didnt mention this earlier in my mail, how do i handle a
 situation where you have you have figures under those years, how do the
 figures manipulate them with formulas for the right figures to appear 
 under
 the respective years


 On Thu, Mar 22, 2012 at 1:13 PM, Maries talk2mar...@gmail.com wrote:

 HI,

 PFA.

 Regards,

 MARIES.

 On Thu, Mar 22, 2012 at 4:40 PM, hilary lomotey resp...@gmail.comwrote:

 Hi Oxford Excel Gurus

 In the fill attached sheet PL i have been able to write a formula
 that can show how many number of years i want to view the report ie if i
 want to see 5 years report i will select from the drop down, and so 
 forth.
 and the number o years specified will show

 In the 2nd sheet ie PL (2) I have also written a formula to  view
 which year the report should begin from say year 2007 , or 2008 etc.

 the problem is how to combine these two formulae into one when i can
 have a situation where i can select a particular year to view the report
 and specify how many years from there to view the report.

 kindly help with a formula. tx


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com



  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-23 Thread Kris

Hi

on Sheet1

In D2:D5 

 FML  SIC  GCB  GGBL 
and define the range *'ShtName*'

Define B2 '*SheetSelected*'

In A12 and copied down  across on PL(2)

=IF(COLUMNS($A12:A12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(A$12:A12),COLUMNS($A12:A12)),)

Kris




-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-23 Thread hilary lomotey

Kris, this solution is spot  on. thanks working to perfection

On Fri, Mar 23, 2012 at 3:33 PM, Kris krishnak...@gmail.com wrote:

 Hi

 on Sheet1

 In D2:D5

  FML  SIC  GCB  GGBL
 and define the range *'ShtName*'

 Define B2 '*SheetSelected*'

 In A12 and copied down  across on PL(2)


 =IF(COLUMNS($A12:A12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(A$12:A12),COLUMNS($A12:A12)),)

 Kris


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-23 Thread hilary lomotey

i think i get excited over the first few trials but i just realised a few
bug .the figures doesnt match the years when you for instance select a
year to view

On Fri, Mar 23, 2012 at 3:41 PM, hilary lomotey resp...@gmail.com wrote:

Kris, this solution is spot on. thanks working to perfection

On Fri, Mar 23, 2012 at 3:33 PM, Kris krishnak...@gmail.com wrote:

on Sheet1

In D2:D5

FML SIC GCB GGBL
and define the range *'ShtName*'

Define B2 '*SheetSelected*'

In A12 and copied down across on PL(2)

=IF(COLUMNS($A12:A12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(A$12:A12),COLUMNS($A12:A12)),)

Kris

--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-23 Thread Kris

OK. In B12 and copied down  across,

=IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MATCH($H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0)+COLUMNS($B12:B12)-1),)

Kris




-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-23 Thread respuzy

Hi Kris

Pls why is it that when you select ALL YEAR from cell H4 it seem to give a 
error?  
Sent from my BlackBerry® smartphone from Airtel Ghana

-Original Message-
From: Kris krishnak...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 23 Mar 2012 08:52:30 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel formula help needed

OK. In B12 and copied down  across,

=IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MATCH($H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0)+COLUMNS($B12:B12)-1),)

Kris

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-23 Thread Kris

Hi

In B3 on Sheet1

=IFERROR(MATCH('PL 
(2)'!$H$4,INDIRECT('INDEX(ShtName,ShtSelected)'!A4:i4),0),2)

Define B3 '*MatchCol'*
*
*
Now in B12 and copy down  across,

=IF(COLUMNS($A12:B12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(B$12:B12),MatchCol+COLUMNS($B12:B12)-1),)

Kris

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-22 Thread Maries

HI,

PFA.

Regards,

MARIES.

On Thu, Mar 22, 2012 at 4:40 PM, hilary lomotey resp...@gmail.com wrote:

 Hi Oxford Excel Gurus

 In the fill attached sheet PL i have been able to write a formula that
 can show how many number of years i want to view the report ie if i want to
 see 5 years report i will select from the drop down, and so forth. and the
 number o years specified will show

 In the 2nd sheet ie PL (2) I have also written a formula to  view which
 year the report should begin from say year 2007 , or 2008 etc.

 the problem is how to combine these two formulae into one when i can have
 a situation where i can select a particular year to view the report and
 specify how many years from there to view the report.

 kindly help with a formula. tx


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Annual Report.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-22 Thread hilary lomotey

genius Maries

Great solution. works to perfection.  thanks boss

On Thu, Mar 22, 2012 at 3:56 PM, Maries talk2mar...@gmail.com wrote:

 HI,

 Please find the attached file of Revised one. Ignore Previous one.

 Regards,

 MARIES.


 On Thu, Mar 22, 2012 at 7:07 PM, Maries talk2mar...@gmail.com wrote:

 Hi,

 PFA.

 =IF(B11=,,CHOOSE(Sheet1!$B$2,FML!B5,SIC!B5,GCB!B5,GGBL!B5))

 Regards,

 MARIES



 On Thu, Mar 22, 2012 at 6:00 PM, hilary lomotey resp...@gmail.comwrote:

 PERFECT, exactly what i needed. tx so much.

 sorry i didnt mention this earlier in my mail, how do i handle a
 situation where you have you have figures under those years, how do the
 figures manipulate them with formulas for the right figures to appear under
 the respective years


 On Thu, Mar 22, 2012 at 1:13 PM, Maries talk2mar...@gmail.com wrote:

 HI,

 PFA.

 Regards,

 MARIES.

 On Thu, Mar 22, 2012 at 4:40 PM, hilary lomotey resp...@gmail.comwrote:

 Hi Oxford Excel Gurus

 In the fill attached sheet PL i have been able to write a formula
 that can show how many number of years i want to view the report ie if i
 want to see 5 years report i will select from the drop down, and so forth.
 and the number o years specified will show

 In the 2nd sheet ie PL (2) I have also written a formula to  view
 which year the report should begin from say year 2007 , or 2008 etc.

 the problem is how to combine these two formulae into one when i can
 have a situation where i can select a particular year to view the report
 and specify how many years from there to view the report.

 kindly help with a formula. tx


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com



  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

RE: $$Excel-Macros$$ Excel formula help

2011-07-22 Thread Rajan_Verma

See the attached File, 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu
Sent: Thursday, July 21, 2011 10:54 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel formula help

 

Hi Friends,

 

In the attached sheet wherever we find Opt. (Opt dart and a space) is
replace with # and add with the  previous cell which does not contain
Opt.originally.

 

As per the attached sheet A9,10,11,12 we have to remove Opt.  and add #
with A8 as prefix.

 

Similarly in A3 Opt. 0D1- Remove Opt. and insert # in front of A2 text
i.e AH401A

 

IF there is no Opt. in a particular cell it will remain as it is.

 

Plz help me with formula.

 

Regards,

 

Prabhu

 

 

 

 

-- 

--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Copy of Opt  .xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ Excel formula help

2011-07-21 Thread Daniel

Hi,

You can’t do it with a formula (a formula only changes the value of the cell
which contains it). Either you use the replace command (Ctrl+H) or you have
to use a macro.

Regards.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prabhu
Envoyé : jeudi 21 juillet 2011 19:24
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Excel formula help

 

Hi Friends,

 

In the attached sheet wherever we find Opt. (Opt dart and a space) is
replace with # and add with the  previous cell which does not contain
Opt.originally.

 

As per the attached sheet A9,10,11,12 we have to remove Opt.  and add #
with A8 as prefix.

 

Similarly in A3 Opt. 0D1- Remove Opt. and insert # in front of A2 text
i.e AH401A

 

IF there is no Opt. in a particular cell it will remain as it is.

 

Plz help me with formula.

 

Regards,

 

Prabhu

 

 

 

 

-- 

--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel formula help

2011-07-21 Thread Vikas Chouhan

try this


=IF(ISERROR(REPLACE(A2,FIND(Opt.,A2),3,#)),A2,(REPLACE(A2,FIND(Opt.,A2),3,#)))

On Thu, Jul 21, 2011 at 10:54 PM, Prabhu prabhugate...@gmail.com wrote:

 Hi Friends,

 In the attached sheet wherever we find *Opt. *(Opt dart and a space) is
 replace with # and add with the  previous cell which does not contain
 Opt.originally.

 As per the attached sheet A9,10,11,12 we have to remove Opt.  and add #
 with A8 as prefix.

 Similarly in A3 Opt. 0D1- Remove Opt. and insert # in front of A2 text
 i.e AH401A

 IF there is no Opt. in a particular cell it will remain as it is.

 Plz help me with formula.

 Regards,

 Prabhu





 --

 --
 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=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
One Team One Dream One Goal

Warm Regards,
*Vikas Chauhan*
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
We can't Spell S_*ccess *without U

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel formula help

2011-07-21 Thread ashish koul

try the attached file



On Fri, Jul 22, 2011 at 2:33 AM, Vikas Chouhan vikask...@gmail.com wrote:

 try this



 =IF(ISERROR(REPLACE(A2,FIND(Opt.,A2),3,#)),A2,(REPLACE(A2,FIND(Opt.,A2),3,#)))


 On Thu, Jul 21, 2011 at 10:54 PM, Prabhu prabhugate...@gmail.com wrote:

 Hi Friends,

 In the attached sheet wherever we find *Opt. *(Opt dart and a space) is
 replace with # and add with the  previous cell which does not contain
 Opt.originally.

 As per the attached sheet A9,10,11,12 we have to remove Opt.  and add #
 with A8 as prefix.

 Similarly in A3 Opt. 0D1- Remove Opt. and insert # in front of A2 text
 i.e AH401A

 IF there is no Opt. in a particular cell it will remain as it is.

 Plz help me with formula.

 Regards,

 Prabhu





 --

 --
 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=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 One Team One Dream One Goal

 Warm Regards,
 *Vikas Chauhan*
 E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
 9911868518,
 We can't Spell S_*ccess *without U

 Life is Very beautiful !!!
 ¨`•.•´¨) Always
 `•.¸(¨`•.•´¨) Keep
 (¨`•.•´¨)¸.•´ Smiling!
 `•.¸.•´.

  --

 --
 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=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
http://akoul.posterous.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


P Before printing, think about the environment.

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Opt. .xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ Excel formula help

2011-04-14 Thread Daniel

Hi,

In L8 :

=SUM(OFFSET($D8MONTH(TODAY(

If you are to use todays month.

Cheers.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de vinod rao
Envoyé : mardi 12 avril 2011 19:24
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Excel formula help

 

Hi,

I need a formula adding each month one column.

Attached file has a details.

 

Regards,

Vin

-- 

--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at  http://exceldailytip.blogspot.com
http://exceldailytip.blogspot.com

To post to this group, send email to  mailto:excel-macros@googlegroups.com
excel-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel http://www.facebook.com/discussexcel

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel formula help

2011-04-13 Thread vinod rao

Thank you for your solution.

On Wed, Apr 13, 2011 at 10:19 AM, STDEV(i) setiyowati.d...@gmail.comwrote:

 try this formula and see if it helps

 =SUM(OFFSET($D8:$I8,0,0,1,MONTH(TODAY(



 On Wed, Apr 13, 2011 at 12:23 AM, vinod rao vinod.ma...@gmail.com wrote:

 Hi,
 I need a formula adding each month one column.
 Attached file has a details.

 Regards,
 Vin

 --

 --
 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=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel formula help

2011-04-12 Thread STDEV(i)

try this formula and see if it helps

=SUM(OFFSET($D8:$I8,0,0,1,MONTH(TODAY(



On Wed, Apr 13, 2011 at 12:23 AM, vinod rao vinod.ma...@gmail.com wrote:

 Hi,
 I need a formula adding each month one column.
 Attached file has a details.

 Regards,
 Vin


-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


ctv_Dynamic_Sum_By_Month.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excel Formula Help

2011-02-18 Thread Sanjoy Nath

As Your formula is circular , it will cause error
Go to Excel OptionsFormulaIterationsCheck the box on
restart excel

Error will not get there



On Fri, Feb 18, 2011 at 8:33 PM, vitorjose victor_pa...@cox.net wrote:

 I prepare construction estimates and am required in some cases to add
 costs for providing a performance bond.  I arrive at a total price
 lets say $1,000,000 then add in bond cost at $10 per thousand
 (10,000).  If am successful i receive a contract for 1,010,000 from my
 customer.  When i go to my bonding company to purchase my bond they
 charge me based on the total contact amount, the bond costs me
 10,100.  So you see i am 100 short from what i included in my
 estimate.  This doesn't seem like a big amount but when you get to
 much larger projects  it can be significant.  At first glance this
 could be done by turning on creating a circular reference and turning
 on iteration.  I am wondering if there is any other way of doing this
 which doesn't create a circular reference.

 Thanks for your help
 Victor  P

 --

 --
 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=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)

-- 
--
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=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel Formula - Help needed

Re: $$Excel-Macros$$ Excel Formula - Help needed

Re: $$Excel-Macros$$ Excel formula help need

Re: $$Excel-Macros$$ Excel formula help need

Re: $$Excel-Macros$$ Excel formula help needed

Re: $$Excel-Macros$$ Excel formula help needed

Re: $$Excel-Macros$$ Excel formula help needed

Re: $$Excel-Macros$$ Excel formula help needed

Re: $$Excel-Macros$$ Excel formula help needed

Re: $$Excel-Macros$$ Excel formula help needed

Re: $$Excel-Macros$$ Excel formula help needed

Re: $$Excel-Macros$$ Excel formula help needed

Re: $$Excel-Macros$$ Excel formula help needed

Re: $$Excel-Macros$$ Excel formula help needed

Re: $$Excel-Macros$$ Excel formula help needed

Re: $$Excel-Macros$$ Excel formula help needed

Re: $$Excel-Macros$$ Excel formula help needed

RE: $$Excel-Macros$$ Excel formula help

RE: $$Excel-Macros$$ Excel formula help

Re: $$Excel-Macros$$ Excel formula help

Re: $$Excel-Macros$$ Excel formula help

RE: $$Excel-Macros$$ Excel formula help

Re: $$Excel-Macros$$ Excel formula help

Re: $$Excel-Macros$$ Excel formula help

Re: $$Excel-Macros$$ Excel Formula Help

25 matches

Site Navigation

Mail list logo

Footer information