Dear All Experts
I Attached sheet in detail information,Only say It is possible?
Regards
Amar
--
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) U
Dear Kantilal & Excel Beginner,
Thanks a lot. I really impressed by your quick reply & great Solution.I am
proud of self that I am member of this Group.I think it is difficult to
find but you both solved it formula.
Sir Actually I always read regarding OFFSET formula but cant go in my mind
how to
I would use conditional formatting.
select cell B2
Click Conditional formatting/new rule/Use a formula to determine which
cells to format/.
enter =b2<>B1
Set the format you want - I used a light green fill
Click OK, OK
Select B2
Copy
Select the rest of column B (or as much of column B as you want
Hi Richard,
Please find attached the requested one. Once you are done with first
negative value the macro will jump to another one. The process goes one
until it finds all.
Click Command button on first sheet.
Regards,
Anoop
Sr. Developer
On Thu, Feb 21, 2013 at 6:07 AM, Richard Bridges wrote
I can see that you can't share file. Can't you even share sample of fake
data? This can help us a lot to understand your query.
On Wed, Feb 20, 2013 at 9:20 PM, solsbee wrote:
> I have a spreadsheet that the data is keyed in one cell, then multiple
> other cells are populated by the index and m
Here's a simple example attached.
On Wednesday, February 20, 2013 7:33:47 PM UTC-5, Richard Bridges wrote:
>
> Hi guys,
>
> I'd appreciate help with this one, can't quite figure it out. I need to
> search all worksheets in a workbook for a negative number in column K,
> display a msgbox showing
Hi guys,
I'd appreciate help with this one, can't quite figure it out. I need to
search all worksheets in a workbook for a negative number in column K,
display a msgbox showing the cell addresses of the negative cells, and to
exit the macro if a negative number is found. This is probably gibb
You must have File new guidelines
2013/2/21 Ankit jain
> Hello
> Please tell me how can i linking of sheets and different workbooks.
> There is any method that i link different workbooks and extract all
> data in a single workbook.
>
> Thanks
> Ankit Jain
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(
You must have File new guidelines
2013/2/21 Ankit jain
> Dear Expert
> Please tell me how can i link 3-4 workbooks and spreadsheets
>
>
> Thanks & Regards
> ANKIT JAIN
>
> --
> 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 Faceboo
Dear Expert
Please tell me how can i link 3-4 workbooks and spreadsheets
Thanks & Regards
ANKIT JAIN
--
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 RULE
I have a spreadsheet that the data is keyed in one cell, then multiple
other cells are populated by the index and match formula being tied to that
entry. My problem is sometimes I need 5 rows populated and other times I
may need 6. Is there a way to have excel show an error if a cell does not
Anil has solved your query. Thanks to him.
I have one other question though. In column A, why is the formula
inconsistent? Both values are 2 then why one is green and other is red?
On Wed, Feb 20, 2013 at 3:39 PM, अनिल नारायण गवली
wrote:
> Dear Manjunath,
>
> Pl find attached herewith.
>
> Warm
Dear Abhi,
Please find the attached spreadsheet
Rather than input two different formula in two column . Can I get one formula.
Thanks
Manjunath
From: Abhishek Jain [mailto:abhishek@gmail.com]
Sent: 20 February 2013 09:41
To: Manjunath Narayanappa
Cc: excel-macros@googlegroups.com
Subject: R
Can you share an example data from your end so as to establish what exactly
you want?
On Wed, Feb 20, 2013 at 2:57 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Dear Abhi,
>
>
>
> Can I use formula =IF(AND(A6=2,A7>2),"pass","fail") to find pass n fail
>
> =IF(AND(A6=0,A7>
Dear Abhi,
Can I use formula =IF(AND(A6=2,A7>2),"pass","fail") to find pass n fail
=IF(AND(A6=0,A7>0),"pass","fail") even if it pop up "pass" it should show green
& for fail it should show red
Value 0 to 2 = Green
Value greater than 2 = Red
Thanks
Manjunath
From: Abhishek Jain [mailto:abhishek
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
Check attached.
On Wed, Feb 20, 2013 at 2:18 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Yes
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Abhishek Jain
> *Sent:* 20 February 2013 07:09
> *To:* excel-macros@google
Yes
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Abhishek Jain
Sent: 20 February 2013 07:09
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ conditional formatting
Help me understand:
Value 0 to 2 = Green
Value greater than 2 = Red
Is t
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.
21 matches
Mail list logo