Dear Rajan
There is no possibility in Excel 2003?If I want this chart in One cell How
to do it?
On Sat, Sep 15, 2012 at 6:20 PM, Rajan_Verma wrote:
> *If you are using Excel 2010 , spark lines comes with that,*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> *
Hi prince
May be I did not explain you properly see the attachment for requirement
Siraj
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Prince Dubey
Sent: Sunday, September 16, 2012 8:47 PM
To: excel-macros@googlegroups.com
Cc: Prince Dubey; S
Rajan
can u please explain this code in detail? becuase $b1 is a column heading
and can never be ec ? right?
On Sun, Sep 16, 2012 at 7:07 AM, Prince Dubey wrote:
> Hi Rajan,
>
> I like your solution, But i feel you have to modify it so that it can work
> for the dynamic name ranges as rasid ment
Hello All,
Works great!
Thanks to everybody for their time and helpn
Rashid Khan
On Saturday, September 15, 2012 3:52:57 PM UTC+4, prkhan56 wrote:
> Hello Experts,
> I am using Excel 2010 and have the following problem.
> If an employee no. is duplicate and he has worked in both Work Areas
> viz
Hi sharad,
Find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Sun, Sep 16, 2012 at 9:07 PM, sharad jain wrote:
> Dear Experts,
>
> Please help me in calculating operating days in the attached sheet.
>
> There are 2 contracts which will run after one after other. These
Hi Sharad,
Find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Sun, Sep 16, 2012 at 9:07 PM, sharad jain wrote:
> Dear Experts,
>
> Please help me in calculating operating days in the attached sheet.
>
> There are 2 contracts which will run after one after other.
D10=MAX(0,MIN(D$8,$C2)-MAX($B2,D$7)+1)
And drag down and across
Regards,
Sam Mathai Chacko
On Sun, Sep 16, 2012 at 9:07 PM, sharad jain wrote:
> Dear Experts,
>
> Please help me in calculating operating days in the attached sheet.
>
> There are 2 contracts which will run after one after other.
My misunderstanding. In that case, perhaps try to get the uniques in col A and
col C and work from there.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Siraj Momin (BTG)
Sent: Sunday, September 16, 2012 11:02 AM
To: excel-macros@googlegroups.com
Subject: R
Another way
Function MYFUNC(str As String)
Dim strg
With CreateObject("Scripting.Dictionary")
.CompareMode = 1
If str <> "" Then
For Each strg In Split(str, "|")
.Item(Trim$(strg)) = Empty
Next
End If
MYFUNC = Join(.k
Hi Don
Dear members
Actually I want to match the values of col A and Col C with Col E and
Col G ( the values can be in any row in Col. E and Col. G NOT ON THE
SAME ROW) and if matched update the value of Col B to Col. F and the
value of Col D to Col H. Its working fine on small data but on large
Dear Experts,
Please help me in calculating operating days in the attached sheet.
There are 2 contracts which will run after one after other. These start and
end at particular days. There is gap of some days between start of 2nd
contract and end of 1st contract. I need to calculate that for how m
Hi Paul,
Yes,Item master is based on date for each product. It is a sample data (for
reference purpose only) and your understanding described in reply is
correct. However, have knowingly put an errorneous rate in Sales Register
for F001 with date as 1-Apr-12 (rate - 2.5) even though item maste
thanks Don
Pawel
As you see I'm not loosing time "everyday something new" thanks to you mate
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Sunday, September 16, 2012 2:24 PM
Subject: Re: $$Excel-Macros$$ hide column VBA
or one line
For i = 1
Put this function in a REGULAR module. Then =myfunc(a1)
Function myfunc(xx)
Dim nodupes As New Collection
arr = Split(xx, "|")
For i = LBound(arr) To UBound(arr)
On Error Resume Next
nodupes.Add arr(i), arr(i)
On Error GoTo 0
Next i
For i = 1 To nodupes.Count
holder = hol
Does this give the same result? In the data provided, a NEVER matches e
Option Explicit
Sub checksyssystemsas()
Dim r As Long
For r = 2 To Cells(Rows.Count, "a").End(xlUp).Row
If Cells(r, "a") = Cells(r, "e") And Cells(r, "c") = Cells(r, "g") Then
‘msgbox r ONLY one match at row 1129
Cells(r, "
or one line
For i = 1 To ActiveSheet.UsedRange.Columns.Count
If Cells(1, i).Value = 1 Then columns(i).Hidden = True
next i
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: ashish koul
Sent: Sunday, September 16, 2012 5:48 AM
To: excel-macros@googlegroups.com
Sorry
=$G$2:$AC$117 to =$G:$AC
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 16 September 2012 5:40
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Re: Highlight Worked Cells only if the
Employee has work
If want to make it dynamic just change the Applied Range
=$G$2:$AC$117 to =$G:$AA
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince Dubey
Sent: 16 September 2012 5:37
To: excel-macros@google
Hi Rajan,
I like your solution, But i feel you have to modify it so that it can work
for the dynamic name ranges as rasid mentioned in his last post.
regards
prince
On Sunday, September 16, 2012 12:30:09 PM UTC+5:30, Rajan_Verma wrote:
>
> *It can be done without code **J***
>
> * *
>
> *See
Hi Sundarvelan,
Please Paste this formula
=((A2:A8=G2)*1*MAX(E2:E8)) with Ctrl+shift+enter
regards
Prince
On Friday, September 14, 2012 4:50:29 PM UTC+5:30, Sundarvelan wrote:
>
> Dear Friends,
>
> Please help me to find the latest date of a student.
> Thanks
> N.Sundarvelan
> 9600160150
>
Hi Siraj,
As i saw u r using loop on the rang which runs fine on small amount of data
but in case of large amount of data it will take huge time to process so
do one thing instead of looping on the range get all data in an Array then
apply same logic as u r doing one the range.
Or
Please s
Hi,
I wants to highlight those cells whose content is repeated in cells in the
select range.
As we highlight duplicate cell based on cell value, I want to highlight based
on cell content.
Thanks & Rgds.
-Original Message-
From: Prince Dubey
Sender: excel-macros@googlegroups.com
Date:
Hi Vabz,
I hope little more explanation of your problem with one example supporting
your explanation.
regards
prince
On Sunday, September 16, 2012 4:48:29 PM UTC+5:30, Vabz wrote:
>
> Hi
>
> I have range where in each cell i ahve manually punched numbers like; 1,
> 5, 8, 2+3, 5, 6+1 etc in
Hi
I have range where in each cell i ahve manually punched numbers like; 1, 5,
8, 2+3, 5, 6+1 etc in diff cells.
What i want ie ti highlight cell content where particular number is
repeatedly used with different colours.
See atttached sheet for reference.
Rgds.
--
Join official facebook
thanks a lot
Pawel
From: ashish koul
To: excel-macros@googlegroups.com
Sent: Sunday, September 16, 2012 11:48 AM
Subject: Re: $$Excel-Macros$$ hide column VBA
Sub sample()
For i = 1 To ActiveSheet.UsedRange.Columns.Count
If Cells(1, i).Value = 1 Then
Cell
Sub sample()
For i = 1 To ActiveSheet.UsedRange.Columns.Count
If Cells(1, i).Value = 1 Then
Cells(1, i).EntireColumn.Hidden = True
End If
Next
End Sub
On Sun, Sep 16, 2012 at 4:14 PM, pawel lupinski wrote:
> Hi All,
>
> I wonder if you can help me, I'd like to hide all columns if the value
Hi All,
I wonder if you can help me, I'd like to hide all columns if the value in row 1
is equal "1", I've written code but something is not working. I'm new to VBA so
if you can help me. Code is below:
Sub HideColumn()
Dim a As Integer
Range("a1").Select
For a = a + 1 To 10
If ActiveCel
Hi
Thanks.. for acknowledgement!! :)
Happy to Help Excel Lovers..
Cheerz..
Rgds//Vabs
On Saturday, September 15, 2012 5:04:02 PM UTC+5:30, Wassi wrote:
> Hello Vabs.
>
> Hats off bro. Both of your solution are working for me.
> Thank you.
>
> Cheers
>
> On Sat, Sep 15, 2012 at 4:52 PM
ANY SOLUTION POSSIBLE
SIRAJ
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Siraj Momin (BTG)
Sent: Monday, September 10, 2012 5:41 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH
COLUMN E AN
Thanks a lot experts
On Friday, September 14, 2012 5:08:06 PM UTC+5:30, Sj wrote:
>
> Dear Experts,
>
> Can someone please let me know how to lock only selected cell?
>
> Thanks,
> Sharad
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+
It can be done without code J
See the attached file..
I am using custom conditional formatting with the below function
=OR(AND($B2="Ec",$B3="RTG",G2=G3,G2<>"",G3<>""),AND($B1="Ec",$B2="RTG",G1=G2
,G1<>"",G2<>""))
On Range =$G$2:$AC$117
Hope it will be helpful.
Regards
31 matches
Mail list logo
