Dear Priti,
As always you did the great logical solution. Infact i really don't
understand the formula used for data validation in Level2 (very huge long),
but i have got some more ideas on this.
Thanks a lot.
Now i have small help modification in the attached sheet.
Exapmle : If F2 changes
HI Chaya,
PFA
see if it helps,
On Tue, May 21, 2013 at 9:42 AM, Chaya wrote:
> Dear Experts,
>
> Please help in doing data sub validation. Please see the attached
> sample.
>
> What ever I select in the Category No column, the same corresponding item
> should be drop down in H Column.
>
>
oh yeah
its working.. thanks abhi... :D
regards
Prabhu R
On 15 May 2013 10:49, Abhishek Jain wrote:
> Whenever you add, delete, or rename a sheet - just save and close the
> file. When you will open the file again, it will be updated.
>
>
> On Wed, May 15, 2013 at 10:41 AM, Prabhu Pinky
Whenever you add, delete, or rename a sheet - just save and close the file.
When you will open the file again, it will be updated.
On Wed, May 15, 2013 at 10:41 AM, Prabhu Pinky wrote:
> Hi abhi,
>
> thanks for your quick help. it really works fine.
>
> i need one more modification in this querr
Hi abhi,
thanks for your quick help. it really works fine.
i need one more modification in this querry. is it possible if i delete any
sheet in this workbook and it should not show in that list..?
On 15 May 2013 10:36, Abhishek Jain wrote:
> You did not mention that in your earlier query.
>
You did not mention that in your earlier query.
However, attached is the solution to your new requirement.
Regards,
Abhi
On Wed, May 15, 2013 at 10:22 AM, Prabhu Pinky wrote:
> thanks abhi,
>
> but i need this to be listed in drop down menu.
>
>
> regards
> prabhu r
>
>
> On 15 May 2013 10:19,
thanks abhi,
but i need this to be listed in drop down menu.
regards
prabhu r
On 15 May 2013 10:19, Abhishek Jain wrote:
> Here.
>
> This will create a list downwards from the selected cell.
>
> On the Home sheet, select A1 and click the button. If you change the name
> of sheets, or add / re
Here.
This will create a list downwards from the selected cell.
On the Home sheet, select A1 and click the button. If you change the name
of sheets, or add / remove sheets, click on the button again to update.
HTH
Regards,
On Wed, May 15, 2013 at 10:04 AM, Prabhu Pinky wrote:
> Hi experts,
>
ell text are links with
>> hyperlink, that same hyperlink should access from home sheet. (Give the
>> code about hyperlinks)
>> Awaiting your reply .
>> Sajid
>> --
>> Date: Tue, 7 May 2013 10:48:25 +0530
>> Subject: Re: $
blem is if database sheet's cell text are links with
> hyperlink, that same hyperlink should access from home sheet. (Give the
> code about hyperlinks)
> Awaiting your reply .
> Sajid
> --
> Date: Tue, 7 May 2013 10:48:25 +0530
> Subject: Re:
Tue, 7 May 2013 10:48:25 +0530
Subject: Re: $$Excel-Macros$$ Help plz
From: gawlianil8...@gmail.com
To: excel-macros@googlegroups.com; sajidwi...@hotmail.com
Dear Sajid, Pl see the attached workbook. Warm Regards,Gawli Anil
On Tue, May 7, 2013 at 10:19 AM, SAJID MEMON wrote:
From: sajidwi...@h
Hi Priti
Great work, Thanku so much.
Thank
Raeksh k
On Wed, May 1, 2013 at 9:56 AM, priti verma wrote:
> Hi Rakes,
> Yes you can do this without using another column.Please see the
> attachement.
> Regards,
> Priti verma
>
>
> On Tue, Apr 30, 2013 at 6:12 PM, Rakesh kumar wrote:
>
>> Hi priti,
Hi Rakes,
Yes you can do this without using another column.Please see the attachement.
Regards,
Priti verma
On Tue, Apr 30, 2013 at 6:12 PM, Rakesh kumar wrote:
> Hi priti,
> thanks for the help,
> Is it possible without using another column.
>
>
>
> On Tue, Apr 30, 2013 at 5:49 PM, priti verma
Hi priti,
thanks for the help,
Is it possible without using another column.
On Tue, Apr 30, 2013 at 5:49 PM, priti verma wrote:
> Hi Rakesh,
> Please see the attachment.
> Regards,
> Priti verma
>
>
> On Tue, Apr 30, 2013 at 5:22 PM, Rakesh kumar wrote:
>
>> Thanks Prafull
>>
>>
>>
>>
>> On Tue
Hi Rakesh,
Please see the attachment.
Regards,
Priti verma
On Tue, Apr 30, 2013 at 5:22 PM, Rakesh kumar wrote:
> Thanks Prafull
>
>
>
>
> On Tue, Apr 30, 2013 at 4:47 PM, Prafull Jadhav
> wrote:
>
>> Dear Rakesh,
>>
>> find the same.
>>
>> Regards,
>> Prafull jadhav.
>>
>>
>> On Tue, Apr 30, 2
Thanks Prafull
On Tue, Apr 30, 2013 at 4:47 PM, Prafull Jadhav wrote:
> Dear Rakesh,
>
> find the same.
>
> Regards,
> Prafull jadhav.
>
>
> On Tue, Apr 30, 2013 at 4:37 PM, Ahmed Honest wrote:
>
>> Rakesh:
>>
>> Run Pivot table, if no Idea just google it to learn Pivot tables / go to
>> youtub
Dear Rakesh,
find the same.
Regards,
Prafull jadhav.
On Tue, Apr 30, 2013 at 4:37 PM, Ahmed Honest wrote:
> Rakesh:
>
> Run Pivot table, if no Idea just google it to learn Pivot tables / go to
> youtube to learn pivot table. You will learn less time.
>
> Start exploring.
>
> Thanks,
>
>
>
>
>
Rakesh:
Run Pivot table, if no Idea just google it to learn Pivot tables / go to
youtube to learn pivot table. You will learn less time.
Start exploring.
Thanks,
On Tue, Apr 30, 2013 at 2:04 PM, Rakesh kumar wrote:
> Hi Friends,
>
> I have some problem in excel, please help me.
>
> column A
HI PRITI
THNK U ONCE AGAIN
BUT IF THE actual value is more than sum OF ( H5,J5) it shoud not allow
to enter the column neither h5 nor j5)
regardS
On Wed, Apr 24, 2013 at 7:48 PM, priti verma wrote:
> Hi GRKRISHNA,
> Please find the attachment.
> Thanks
> Priti verma
>
>
> On Wed, Apr 24,
Hi GRKRISHNA,
Please find the attachment.
Thanks
Priti verma
On Wed, Apr 24, 2013 at 7:36 PM, GRKRISHNA NAIDU wrote:
> dear PRITI VERMA
>
> THNKS FOR YOUR HELP
>
> WILL YOU PLEASE SHOW ME IN WORK SHEET
>
>
>
>
> On Wed, Apr 24, 2013 at 7:27 PM, priti verma wrote:
>
>> Hi GRKRISHNA,
>>
>> Pleas
dear PRITI VERMA
THNKS FOR YOUR HELP
WILL YOU PLEASE SHOW ME IN WORK SHEET
On Wed, Apr 24, 2013 at 7:27 PM, priti verma wrote:
> Hi GRKRISHNA,
>
> Please use this formula in your data validation.
>
> =IF(SUM(H5+J5)-F5<=F5,"true","false")
>
> Regards;
>
> Priti verma
>
>
> On Wed, Apr 24, 20
Hello,
Please elaborate on this statement "I want formudata for e which is unique
date agains each site"
It s not clear.
Thankyou
On Sat, Apr 13, 2013 at 3:22 AM, Neeraj Chauhan
wrote:
> Dear experts,
>
> ** **
>
> Kindly find the attached sheet
>
> --
> Are you =EXP(E:RT) or =NOT(E
Thank You very much for prompt response!
On Thu, Apr 11, 2013 at 10:22 PM, ashish koul wrote:
> =MID(A1,FIND(5,A1),6)
>
>
>
> On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA
> wrote:
>
>> Hi Team,
>>
>> I need a formula to find anything starting from 5 in a cell and to take 6
>> digit right of
=MID(A1,FIND(5,A1),6)
On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA wrote:
> Hi Team,
>
> I need a formula to find anything starting from 5 in a cell and to take 6
> digit right of the cell starting from 5 as below.
>
> Eg.
>
> DataDesired Result
> ABC 500012 XYZ
On Wednesday, March 20, 2013 12:41:49 PM UTC-4, Sam Mathai Chacko wrote:
>
> Here's an explanation to a similar but not exactly same formula. I'm sure
> you can decipher your equation once you go through the link below.
>
> http://www.excelfox.com/forum/f13/extract-number-alphanumeric-text-186/
>
Here's an explanation to a similar but not exactly same formula. I'm sure
you can decipher your equation once you go through the link below.
http://www.excelfox.com/forum/f13/extract-number-alphanumeric-text-186/
Regards,
Sam Mathai Chacko
On Wed, Mar 20, 2013 at 8:15 PM, Chris wrote:
> Hi Ev
Dear Rakesh,
Pl find attached herewith FYI.
Warm Regards,
Gawli Anil
On Fri, Mar 8, 2013 at 3:53 PM, Rakesh Sharma wrote:
> can we arrange rearrange spellings in Excel column.
>
> like i want to arrange my name
>
> hsekar to rakesh
>
>
> --
> **
> RA
Sure.
1. When you import the text file, choose *Delimited* and put " (inverted
commas) in the *Other* field. This will take address in a separate column.
Adjust the values of addresses by removing first blank cell.
2. After you have imported, insert a column after the name and choose *Text
to Colu
Perfect Abhishek, Thanx a lot, may I ask you, which formulae or
function is been used to do this ? Please...
Regards
Sandeep
On Wed, Feb 20, 2013 at 2:02 PM, Abhishek Jain wrote:
> Does this work for you?
>
>
> On Wed, Feb 20, 2013 at 1:46 PM, Sandeep wrote:
>>
>> Thanx Abhishek,
>>
>> Still w
Does this work for you?
On Wed, Feb 20, 2013 at 1:46 PM, Sandeep wrote:
> Thanx Abhishek,
>
> Still waiting for my query to be resolved, meanwhile I'm sharing the
> .txt file for your better insight.
>
>
> Regards
>
> Sandeep
>
> On Wed, Feb 20, 2013 at 12:34 PM, Abhishek Jain
> wrote:
> > Hi
Thanx Abhishek,
Still waiting for my query to be resolved, meanwhile I'm sharing the
.txt file for your better insight.
Regards
Sandeep
On Wed, Feb 20, 2013 at 12:34 PM, Abhishek Jain wrote:
> Hi Sandeep,
>
> Welcome to the group. I hope that the experts here would help resolve your
> query.
Hi Sandeep,
Welcome to the group. I hope that the experts here would help resolve your
query.
Meanwhile, could you also share with us the text file (in its original
format) from which you have imported this data. I believe it would help in
getting a better insight.
Thanks,
Abhishek
On Wed, Fe
Hi Sriram,
Try this "=SUBSTITUTE(A206,CHAR(160),"")"
On Sat, Feb 2, 2013 at 5:31 PM, sriram ji wrote:
> Dear Excel Guru,
>
> I want remove space after the data. Any one can suggest Excel formula for
> below attached file.
>
> Thanks & Regards,
> Sriram G
> Chennai.
>
>
>
> --
> Ar
Hi Hemanath,
You can sum to be included "No Of Days Present".
--
*Regards,*
*
*
*Excel Beginner*
On Tue, Jan 29, 2013 at 10:50 PM, hemanath dhanasekar
wrote:
> Thanks the formula is working, but I dont see any changes in "No Of Days
> Present" column this column also sho
Thanks the formula is working, but I dont see any changes in "No Of Days
Present" column this column also should increase by 0.5.
On Tue, Jan 29, 2013 at 10:28 PM, >>Excel Beginner<< <
excelbegin...@gmail.com> wrote:
> Hi Hemanath,
>
> Use the following formula or more clari
Hi Hemanath,
Use the following formula or more clarity find the
attachment.
=COUNTIF(*C3:AG3*,"H")*0.5
--
*Regards,*
*
*
*Excel Beginner*
On Tue, Jan 29, 2013 at 9:51 PM, hemanath dhanasekar wrote:
> Gawli,
>
> This is not the answer I am lookin
Gawli,
This is not the answer I am looking for, The "Half day " column should be
0 initially and when ever I update H in the date column then the Half day
column should add up by 0.5 and if I update another H on another date then
Half day column should show as 1 (ie 0.5+0.5). and simultaneously "
SEE THE ATTACHED SHEET
WARM REGARDS,
GAWLI ANIL
On Tue, Jan 29, 2013 at 1:52 PM, hemanath dhanasekar wrote:
> Experts,
>
> Help me in providing a formula to calculate the Half day in the attached
> Attendance Tracker.
>
> If I enter H in the column the Half day column should add up by 0.5 and No
Dear Chaya ,
If u dont want the screen undating then after Sub proc_ExtractDates()
write
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Then their will be no screen changing
warm Regards,
Gawli Anil
On Thu, Jan 17, 2013 at 12:23 PM, Anoop K Sharma wrote:
> I have restricte
I have restricted the flickering of screen. Use below the updated one.
Paste the below code in the module. Press alt + F8 and run macro
proc_ExtractDates.
Remember you are getting output on worksheet named as "Sheet5". If it
doesn't exist then make a new worksheet with this name.
Sub proc_Extra
Paste the below code in the module. Press alt + F8 and run macro
proc_ExtractDates.
Remember you are getting output on worksheet named as "Sheet5". If it
doesn't exist then make a new worksheet with this name.
Sub proc_ExtractDates()
Dim i As Integer
Dim lRow As Long
Dim fndVal As Va
Dear Anoop sir,
i have tried for the same for 100 sheets, which contains the same,
there nothing value is coming. i mean is there any bound for number of
sheet, like maximum of 6 or 7 sheet. what you have provided to me is
excellent working but i try for 100 sheets , the data is missing.
Dear Anoop,
Awesome and unbelievable, it was more then expected. any way i did
not check those value. once i check, i revert you back.
thanks for helping me. thank you all.
-Chaya
On Thu, Jan 17, 2013 at 11:19 AM, Anoop K Sharma wrote:
> Hi Chaya
>
> Here you go
> Note:- You can
Pl provide a meaningfull subject.
Warm Regards,
Gawli Anil
On Fri, Jan 11, 2013 at 10:57 AM, joginder kumar wrote:
> HI GUROPS MEMBER ,
>
>
> PLEASE HELP REGARDING THIS SHEET .
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use
Hi Anoop,
That code was really helpful. I modified it to help do what I was trying to
do. The only problem I have now is that It only seems to apply the type to
the first match it finds and disregards the rest of them. Any Idea how I
would be able to apply the code to the rest of the rows?
H
Hi, i put the link at the bottom of. my question.
tx
here is the link with the spreadsheet
https://www.box.com/s/33z5kuabqbjn2b971ae6
matt
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread t
Hi, i put the link at the bottom of my question.
tx
matt
--
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 Ad
Matt, Please share your workbook.
Regards,
Anoop
Sr. Developer
On Sat, Dec 15, 2012 at 9:58 PM, Matt wrote:
> Hi, search the forum but couldn't find an example that fit. I'm trying to
> do a search off column "A" on the "Lookup" tab, and search for it in the
> yellow column in the "2010Chase"
Dear Sanjay,
U cannot give same name to two sheets. And while inserting the default name
will be "Sheet and the number ".
II'm guessing that u want the name while inserting a blank sheet . a name
which is defined by U and not the excel program.
If i'm guessing right then logic is
*Sub AddWorkshe
Each sheet in a workbook has to have a different name from any other sheet
in the same workbook.
Subject to that constraint you can change the name of the inserted sheet
after you have created it.
Can you give more detail of what you are doing. Ie how you are inserting
the sheet, what name you want
Dear Neeraj,
Pl find attached.
Regards,
Gawli
On Wed, Dec 12, 2012 at 12:28 PM, neeraj chauhan wrote:
> Dear Experts,
>
> kindly find the attached sheet. i want to make the conditional format, but
> how to make. revert me
>
> --
> Join official Facebook page of this forum @
> https://www.facebo
*Mr Neeraj,*
*Pl always write the useful subject to your mails to get immediate response
on your queries...*
*
*
*Regards,*
*Pravin.
*
On Mon, Dec 10, 2012 at 5:02 PM, neeraj chauhan
wrote:
> Dear Experts,
>
> kindly find the attached sheet, this long file i am not able to pivot. i
> am not able t
Have you noticed Forum Rule #1?
---
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.
---
Hi neeraj,
see the attachment.
--
***Best Regards,
Ms Excel User
*
On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan
wrote:
> Dear Experts,
>
> kindly find the attached sheet.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RU
Hi,
use this =ROUND(C3,2)
On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan
wrote:
> Dear Experts,
>
> kindly find the attached sheet.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use
hi Neeraj,
You can just use the Ctrl+Shift+~ key for general format.
Aamir Shahzad
On Fri, Nov 2, 2012 at 5:21 PM, sunil jagtap wrote:
> Hi Neeraj,
>
> Please try below formula
>
> =ROUND((C3*100),2)
>
> Thanks and Regards,
> Sunil
>
>
>
> On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan > wrote
Hi Neeraj,
Please try below formula
=ROUND((C3*100),2)
Thanks and Regards,
Sunil
On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan
wrote:
> Dear Experts,
>
> kindly find the attached sheet.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RU
There are several different types of loops.
The type you select will depend on your specific situation.
a couple of examples would be:
'---
Sub Loop1()
Dim Rng As Range
For Each Rng In Range("A2:A10")
MsgBox Rng.Value
Next Rng
Hi Xlts,
Thanks for all your Inputs and suggestions.
Finally I could able to Sort it Out by Countif and Vlookup Function.
Please refer the file attached.
thanks,
Saravanan
On Thu, Oct 25, 2012 at 10:11 AM, अनिल नारायण गवली
wrote:
> Pl Share a sample sheet with us
>
>
> On Thu, Oct 25, 2012 at
Pl Share a sample sheet with us
On Thu, Oct 25, 2012 at 9:52 AM, David Grugeon wrote:
> It seems to me that sorting might be a better approach than a vlookup.
>
> Regards
> David Grugeon
>
>
> On 25 October 2012 14:15, Saravanan wrote:
> > Hi
> >
> > I need this because need to know which are a
It seems to me that sorting might be a better approach than a vlookup.
Regards
David Grugeon
On 25 October 2012 14:15, Saravanan wrote:
> Hi
>
> I need this because need to know which are all the items belongs to one
> value. By this values I can assign the items need to work.
>
> Thanks,
> Sar
Hi
I need this because need to know which are all the items belongs to one value.
By this values I can assign the items need to work.
Thanks,
Saravanan.
On Oct 25, 2012, at 12:13 AM, Paul Schreiner wrote:
> Are you saying that your VLookup Value occurs in multiple rows in your table?
> or th
Are you saying that your VLookup Value occurs in multiple rows in your table?
or that you want to return multiple values from the single match?
Then.. what do you want to do with the results?
Paul
-
“Do all the good you can,
By all the means you can,
In al
In addition to the below post, you cannot use Sumproduct to get the Text
Data as result.
<><><><><><><>
*Ms-Exl-Learner*
<><><><><><><>
On 10-10-2012 11:13 PM, Kuldeep Singh wrote:
Hi Srinivas,
Please use this.
=SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
Regards,
Kuldeep Sing
Dear Sriram,
Please try it..
Sub NTest()
Dim a$, b$, c$
Dim i%
a$ = Range("A1").Value
For i = 1 To Len(a$)
b$ = Mid(a$, i, 1)
If b$ Like "[A-Z,a-z,0-9 ]" Then
c$ = c$ & b$
End If
Next i
Range("B1").Value = c$
End Sub
On Wed, Oct 10,
Dear Shrinivas,
You can try it..
With Additional column it is possible through vlookup
=VLOOKUP(CONCATENATE(H3,I3,J3,K3),$A$2:$F$5,6,0)
Or
=INDEX($E$2:$E$5,MATCH(1,($A$2:$A$5=G3)*($B$2:$B$5=H3)*($C$2:$C$5=I3)*($D$2:$D$5=J3),0))
with cse
or
=LOOKUP(9E+300,1/(($A$2:$A$5=$G$3)*($B$2:$B$5=$H$3)*
Thanks to all
Great Help
Thanks once again
Regards
Shrinivas
On Wed, Oct 10, 2012 at 11:13 PM, Kuldeep Singh wrote:
>
> Hi Srinivas,
>
> Please use this.
>
> =SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
>
> Regards,
> Kuldeep Singh
>
>
> On Wed, Oct 10, 2012 at 10:55 PM, >>Excel Beginn
Hi Srinivas,
Please use this.
=SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
Regards,
Kuldeep Singh
On Wed, Oct 10, 2012 at 10:55 PM, >>Excel Beginner<< <
excelbegin...@gmail.com> wrote:
> Hi Shrini,
>
>Find the Attachment.
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
>
Hi Shrini,
Find the Attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Oct 10, 2012 at 5:53 PM, Shrinivas Shevde wrote:
> Dear All
>
> Is it possible to use Vlookup with multple conditio. i e.
> Can I get the value From Column E if All the column a,b,c,d matches.
>
> Thanks
Hi Sriram,
Use this =SUBSTITUTE(A1,"!","") and you are change to the
special character.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Oct 10, 2012 at 4:02 PM, sriram ji wrote:
> Dear Excel Guru,
>
> Any formula for removing special character ex (!, -, &,~,?,_,;,',). Please
>
Hi Shrini,
Please share a sample worksheet.
Regards,
Kuldeep Singh
On Wed, Oct 10, 2012 at 5:53 PM, Shrinivas Shevde wrote:
> Dear All
>
> Is it possible to use Vlookup with multple conditio. i e.
> Can I get the value From Column E if All the column a,b,c,d matches.
>
> Thanks in advance
>
> -
Hi,
Here is another solution without inserting exta column "Column D".
Don't ask me to explain this formula, because I also don't know how it
works. [?] I get this formula from net and just modified it.
Following is the link from where I get it.
http://www.excelforum.com/excel-formulas-and-funct
Hi,
Pls find attached excel.
Check if it is ok with you.
Regards,
Swapnil.
On Wed, Oct 10, 2012 at 1:41 PM, Henning Deschka wrote:
> Hi all,
>
> thank you all for your help and time that you spend to solve this problem!
> I am very happy with the solution that Ashish attached.
>
> This solut
Hi all,
thank you all for your help and time that you spend to solve this problem!
I am very happy with the solution that Ashish attached.
This solution works perfect and I am very happy with it - thank you!
Unfortunately, I forgot to mention something important yesterday ...
I need this fu
see the attachment check the cells with "Yellow" color
On Tue, Oct 9, 2012 at 8:48 PM, Swapnil Palande wrote:
> Hi,
>
> Insert followibg formula in D1 cell.
>
> =if(and(or(a1=1,b1=1),c1>23400),3,0)
>
> Hope this is what u want.
>
> Regards
>
> swapnil,
> On Oct 9, 2012 6:57 PM, "Henning Deschk
Hi,
Insert followibg formula in D1 cell.
=if(and(or(a1=1,b1=1),c1>23400),3,0)
Hope this is what u want.
Regards
swapnil,
On Oct 9, 2012 6:57 PM, "Henning Deschka" wrote:
> Hi NG,
>
> I need to insert a function into cell D1 with an Excel2007 macro that
> executes the following:
>
>
its working fine All cells marked with green are input cells . Just follow
the instructions and enter the data in requested format only
On Sat, Oct 6, 2012 at 2:51 PM, Hari Nair wrote:
> I am attaching an excel utility file which I have downloaded form Central
> Excise Web site to File online re
Hi Mangesh
Can you send file as Excel 2003.Then I will try to solved your problem.
On 10/3/12, Mangesh Vimay wrote:
> Hi Rajan,
>
> Its sample data I have provided but the data range would remain same.
>
> Please provide solution.
> Thanks !!!
>
> On Wed, Oct 3, 2012 at 6:43 PM, Rajan_Verma
> wro
Thanks jeet!!
On Thu, Oct 4, 2012 at 3:27 PM, jeet singh wrote:
> Dear Friend,
>
> Plz find the attached file.
>
>
>
> On Thu, Oct 4, 2012 at 2:40 PM, Neeraj wrote:
>
>> Dear Experts
>>
>> ** **
>>
>> Kindly see the attached sheet and urgently req.
>>
>> --
>> Join off
Dear Friend,
Plz find the attached file.
On Thu, Oct 4, 2012 at 2:40 PM, Neeraj wrote:
> Dear Experts
>
> ** **
>
> Kindly see the attached sheet and urgently req.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM
Hi Rajan,
Its sample data I have provided but the data range would remain same.
Please provide solution.
Thanks !!!
On Wed, Oct 3, 2012 at 6:43 PM, Rajan_Verma wrote:
> *Is your data suitable for all chart type ? *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
Is your data suitable for all chart type ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mangesh Vimay
Sent: 03 October 2012 6:39
To: excel-macros@googlegroups.com; Mangesh Vimay
Subject: $$Excel-M
Thanks a lot Rajan and Ashish I really appreciate your knowledge
and great help
On 10/2/12, ashish koul wrote:
> try the attachment change c38 as per ur last row
>
>
>
> On Tue, Oct 2, 2012 at 10:56 AM, Rajan_Verma
> wrote:
>
>>
>> Try this
>>
>> =IF(C1="",IF(SUMPRODUCT(N($B$1:$B$16=B1)*N
Try this
=IF(C1="",IF(SUMPRODUCT(N($B$1:$B$16=B1)*N($C$1:$C$16<>"")*$F$1:$F$16)=F1,"Y
es","No"),"")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur kochar
Sent: 02 October 201
HI
Inn short 5 & 10 is row no. in which Sam & Ram is written.
Rgds//Vabs
On Wednesday, September 26, 2012 1:31:47 PM UTC+5:30, amar takale wrote:
>
> Hello Vabz
> Thanks for Logic based on your criterion formula But Can you explain
> it.What is minus Row 5 & Row 10 logic.I cant Understand it.
Hello Vabz
Thanks for Logic based on your criterion formula But Can you explain
it.What is minus Row 5 & Row 10 logic.I cant Understand it.In my data
there are 9 column & 13 Row but it is different for different name as per.
I will use it but not work I use it & minus Row 8 in formula But formula
Need help.
On Tue, Sep 25, 2012 at 2:38 PM, amar takale wrote:
> Hi Vabz
> I will try it but how to range criteria.Bcos after giving formula I used
> data validation for name.If I click Name Then all other criteria show inone
> shot.
>
>
> On Tue, Sep 25, 2012 at 12:00 PM, Vabz wrote:
>
>> Dear
Hi Vabz
I will try it but how to range criteria.Bcos after giving formula I used
data validation for name.If I click Name Then all other criteria show inone
shot.
On Tue, Sep 25, 2012 at 12:00 PM, Vabz wrote:
> Dear Amar
>
> You can use sumproduct for your query
>
> Rgds
>
>
> On Monday, Septemb
Dear Amar
You can use sumproduct for your query
Rgds
On Monday, September 24, 2012 7:01:25 PM UTC+5:30, amar takale wrote:
>
> Pls find attached below file
>
> See Attached file.
>
> On Mon, Sep 24, 2012 at 6:43 PM, amar takale
> > wrote:
>
>> Dear Group Members,
>>
>>
>>
>> Please Solution
Hi Amar
Why do you need to use Vlookup and Match, rather than VBA? Is this
homework? If so you will need to find out about array formulas to
work out the solution.
If not, can you explain a bit more about the application, how it will
be used, who will use it (Just you or other people?) whether
Pls find attached below file
See Attached file.
On Mon, Sep 24, 2012 at 6:43 PM, amar takale wrote:
> Dear Group Members,
>
>
>
> Please Solution Need!
>
>
>
> I need to apply Vlookup+Match formula to get value in sheet1 (C5 to F5)
> cell But it show same Output below.
>
>
>
>
>
> Sheet1 (C5 to
Dear Sundarvelan,
You can try this.
=INDEX($B$2:$B$20,MATCH(K2,$D$2:$D$20,0),1) Paste it I2 &
Ctrl+Shift+Enter.
=INDEX($C$2:$C$20,MATCH(K2,$D$2:$D$20,0),1) Paste it J2 &
Ctrl+Shift+Enter.
Regards,
Kuldeep Singh
On Thu, Sep 6, 2012 at 6:46 PM, Rajan_Verma wrote:
> *=INDEX($B$1:$F$20,MATCH(
=INDEX($B$1:$F$20,MATCH(K2,$D$1:$D$20,0),1)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: 06 September 2012 12:37
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ HELP
Dear Sundar,
You can use single Vlookup for both required Column
*=VLOOKUP(K2,CHOOSE({1,2,3},$D$2:$D$20,$B$2:$B$20,$C$2:$C$20),{2,3},0)
*
with ctrl+shift+enter
See attached sheet for more clarity.
On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N wrote:
> Dear Friends,
>
> Help me to find the
PFA
On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N wrote:
> Dear Friends,
>
> Help me to find the circle and area. Please find the attached file for
> your reference.
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexc
Thank you its working
On Mon, Sep 3, 2012 at 5:22 PM, Amresh Maurya wrote:
> Hi Rambabu,
>
> Find the attached file.
>
> use this formula.
>
> =SUMIFS(I15:I24,K15:K24,"<"&O15,J15:J24,N15)
>
> Regards
> Amresh
>
>
>
>
> On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI
> wrote:
>
>> Please try
>>
Hi Rambabu,
Find the attached file.
use this formula.
=SUMIFS(I15:I24,K15:K24,"<"&O15,J15:J24,N15)
Regards
Amresh
On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI wrote:
> Please try
>
> =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15)
>
>
> On Mon, Sep 3, 2012 at 5:17 PM, Rambabu
Dear Ram,
If you working in prior version of Excel 2007
You can use
=SUMPRODUCT(($J$15:$J$24=N15)*($K$15:$K$24<=O15)*($I$15:$I$24))
On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI wrote:
> Please try
>
> =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15)
>
>
> On Mon, Sep 3, 2012 at 5:17
Please try
=SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15)
On Mon, Sep 3, 2012 at 5:17 PM, Rambabu Mudiraj wrote:
> Dear all,
>
>
> --
> Regards
> Rambabu. G
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members alre
t;
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde
> *Sent:* 01 September 2012 1:01
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help on Formula
>
> ** **
>
> Dear Rajan
&g
301 - 400 of 1327 matches
Mail list logo
