*LEARN and SHARE ideas for comfort life using EXCEL*
On Fri, Feb 25, 2011 at 9:49 AM, Rohan Young wrote:
> Dear Ayush Ji,
> Welcome & thanks to you for your appreciation
> Regd
>
> ROHAN
> On Thu, Feb 24, 2011 at 9:49 PM, Ayush wrote:
>>
>> Dear Friends,
>>
>> I liked most of the tag lin
Expert Team,
I’m struck. What I’m trying to do is create a macro that will average
a series of numbers and replace the numbers in the predefined series
with that average number. Currently I’m assuming two variables. One
macro for a set of 4 numbers, and one set for a series of 5 numbers.
The fol
Apply:res...@msysinc.com
Job Responsibilities:
Buildout and support Excel VBA / SQL application
Buildout SQL access controls
Convert MSAcess 97 apps to 2007 or newer version
Skills:
Database Design
Application Development
Tools:
Microsoft SQL Server 2005
Microsoft VBA
Visual Basic for Appli
Range("E1:e" & i).Formula = "=$A$" & i - 1 & " - " & "$B$" & i - 1 ' *Does
work*
On Fri, Feb 25, 2011 at 4:47 AM, Nasim wrote:
> Hi,
>
> I am trying to enter the folowing formula in cells but whatever I do I
> can not make the "-" part work and it just enters a dash in the cell:
> i tries chr(34
Dear Ayush Ji,
Welcome & thanks to you for your appreciation
Regd
ROHAN
On Thu, Feb 24, 2011 at 9:49 PM, Ayush wrote:
> Dear Friends,
>
> I liked most of the tag linesand appreciate your contribution.
>
> Especially simple ones : Excel Simplified.
> Special Thanks to Rohan & Thamu for gi
Hi Puttu,
it is working well see the attachment, r u sure you are putting right
criteria in your data, pls. send the sample sheet for understanding,
Thanks & Regd
ROHAN
On Thu, Feb 24, 2011 at 8:16 PM, Puttu * wrote:
> Team, Please help me on this
>
> On Thu, Feb 24, 2011 at 6:13 PM, Puttu *
Hi,
see the attachment if it help
thanks & regds,
ROHAN
On Thu, Feb 24, 2011 at 8:05 PM, John A. Smith wrote:
> Your kind help please.
>
> I have a database that I need to see duplicated rows but can't filter
> because some columns can legitimately repeat. If the entire row is a
> duplicate,
There is no attachment
On Thu, Feb 24, 2011 at 6:33 PM, Joao Matoso wrote:
> Ww
>
> NOORAIN ANSARI escreveu:
>
> >Dear Experts..
> >
> >Please find attached query sheet...I want to add a seperate row after
> every
> >semicolon..
> >
> >Please see attached sheet..
> >
> >--
> >Thanks & regards,
Hi,
I am trying to enter the folowing formula in cells but whatever I do I
can not make the "-" part work and it just enters a dash in the cell:
i tries chr(34) & "-" & chr(34) and it did not work either.
I need range(E2)= $A$1 & " - " & $B$1
.Range("E" & i).Formula = "=$A$" & (i - 1) & " & " &
Using conditional formatting it seems to work like this. Select your range
and then on the conditional formatting menu change to Formula and insert the
below formula, pick how you want it highlighted.
=COUNTIF($A$2:$E$5000,A2:IS2)>1
I'm no expert, but I was able to figure it out. Perhaps one of t
Combine the cells like so... A1&B1&C1 etc then use COUNTIF
with the coniditional formatting. For example in G2 put
=A2&B2&C2&D2&E2 (you can hide column H). Then for the conditional
formatting start at A2 and use formula =IF(A2<>"",IF(COUNTIF($G:$G,
$G2)>1,TRUE,FALSE))
On Feb 24, 9:35 am, "
HI Mahesh Sir,
Thanks for the such a nice code but it is just 2nd portion of the code i
think you have not add the 1 part which we have discussed at afternoon and
onemore thing that i have given u the process base test columns to be
deleted after the filter which we have discussed alreay
Request
Hi Maulik,
I am sure you will get it resolved if you explain your expectation with some
more brief about the way of pulling the data with cell reference and how it
can be derived.
Because you know very well about your data and the way your expected result.
But for us the data is a new one and we
Team, 1'm looking for support with the "SubTotal" function in excel
2007 or 2010. I'm looking to insert a blank row between the subtal
line, and the next group. Note: the subtoal line exists in column A.
Any Ideas?
Thanks for your support
--
--
Dear Friends,
I liked most of the tag linesand appreciate your contribution.
Especially simple ones : Excel Simplified.
Special Thanks to Rohan & Thamu for giving creative Tag Lines.
Keep telling me , so that I have more options till the launch.
Thanks and Best Regards
Ayush Jain
On Wedne
Team, Please help me on this
On Thu, Feb 24, 2011 at 6:13 PM, Puttu * wrote:
> Hi Experts,
>
> I have two questions
>
> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in this
> if any error it shows as #N/A, insted of this i want it show as balnk, how
> to do this?
>
> 2. In
Your kind help please.
I have a database that I need to see duplicated rows but can't filter
because some columns can legitimately repeat. If the entire row is a
duplicate, I need to know.
Please see attached example. Thanking you in advance for your continuing
help in learning Excel.
John
--
see if it helps
On Thu, Feb 24, 2011 at 6:13 PM, Puttu * wrote:
> Hi Experts,
>
> I have two questions
>
> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in this
> if any error it shows as #N/A, insted of this i want it show as balnk, how
> to do this?
>
> 2. In Vlookup form
http://www.excelitems.com/2010/12/excel-vba-interview-questions.html
On Thu, Feb 24, 2011 at 7:41 PM, vijayajith VA wrote:
> Hai Excel Kings;;;
>
> I am new to vba and excel . i need to attend the interviews..
>
> Can you mail some imp excel and macros questions with answers...
>
> Please its ver
Hai Excel Kings;;;
I am new to vba and excel . i need to attend the interviews..
Can you mail some imp excel and macros questions with answers...
Please its very urgent
Thankyou
--
--
Some important links for exc
I have the file stored on Google Docs at:
https://docs.google.com/leaf?id=0B2wwdgJj4ncpYzQ0MTFiNzQtNDAxMi00NGNmLWIzMjMtYmM0NjQyNTY3Y2Nm&hl=en&authkey=CLjt6zY
On Feb 23, 4:01 pm, Ken Hansen wrote:
> Hi all,
>
> I have a Sales Tracking workbook. I have 2 issues that I can't seem to
> resolve.
>
> 1
PERFICT
IT IS WORKING VERY GOOD
THANKS ASHISH KOUL
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Thursday, February 24, 2011 8:47 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Insert Row after Change in Value
Dear Excel Guru/Ashish,
Thanks for your valuable solution.But the problem is still here, Because I
want to print it according to MRP & Dcode wise on different sheet of paper,
I know page break works but doing page break on every dcode and MRP is very
tough task wwhen data is too large.Pivot table
Ww
NOORAIN ANSARI escreveu:
>Dear Experts..
>
>Please find attached query sheet...I want to add a seperate row after every
>semicolon..
>
>Please see attached sheet..
>
>--
>Thanks & regards,
>Noorain Ansari
>
>--
>---
Simply searching the group for pdf to excel would've given you several
potential answers. I did not check this URL but here is one possible
software answer.
Link to answer:
http://groups.google.com/group/excel-macros/browse_thread/thread/b6fae3eee31606ec/d32d131c316fa8d4?lnk=gst&q=pdf+to+excel#d32
Hi Experts,
I have two questions
1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in this
if any error it shows as #N/A, insted of this i want it show as balnk, how
to do this?
2. In Vlookup formula if the result is found in different excel, i want that
sheet name to be visibl
*Hi.. Experts & Excel guru
I need ur help.. pls help me..
Thnx
Karan
*
ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
ht
Dear Experts..
Please find attached query sheet...I want to add a seperate row after every
semicolon..
Please see attached sheet..
--
Thanks & regards,
Noorain Ansari
--
--
Some important links for excel users:
1.
Hello,
Some people have this habit ; it’s useless.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jenie
Envoyé : mercredi 23 février 2011 20:38
À : excel-macros@googlegroups.com
Objet : RE: $$Excel-Macros$$ Macro Help - Please!
Hello excel e
*Thnx..
*
ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı
On Thu, Feb 24, 2011 at 10:15 AM, Rohan Young wrote:
>
>
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
>
> 2011/2/23 кαяαηη yα∂αν
>
>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
30 matches
Mail list logo