Hi Karthik,
Pls see the attachment.
regards
Prince.
On Thursday, October 4, 2012 7:14:56 PM UTC+5:30, karthik n wrote:
>
> Hi Team,
>
> Please help in the attachment file
>
> Regards
> karthik.N
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORU
Hi Dharti kumar,
Please explain it more
regards
prince
On Thursday, October 4, 2012 11:44:01 AM UTC+5:30, Dhartikumar Sahu wrote:
>
> hi Group
>
> Can u please help me out in this problem. I have an query of Multiple if
> conditions
>
> if % Column true then result will be shown in solution.
Hi Mangesh,
I feel the data you have provided is not suitable for the all the chart
type that you have mentioned into your sheet. pls confirm us the logic by
which your chart should be displayed .
regards
prince
On Wednesday, October 3, 2012 6:39:04 PM UTC+5:30, Mangesh wrote:
>
> Hi Frien
On Wednesday, October 3, 2012 1:13:28 PM UTC+5:30, Manoj Kumar wrote:
>
> Hi Prince,
>
> X is my folder name witch has many mail's of outlook..every mail has a
> excel attachment..
>
> Regard
> Manoj
>
> On Wed, Oct 3, 2012 at 12:52 PM, Prince Dubey
>
>
Hi Manoj,
I their any sub folder inside forlder X ?
Regards
Prince
On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote:
>
> Dear Export,
>
> I have one folder "x" witch has contain mail's, every mail contain an
> excel file,
> i want to copy all excel file from folder "x" to
Nice solution...
Regards
Prince
On Wednesday, October 3, 2012 11:46:01 AM UTC+5:30, §»VIPER«§ wrote:
>
> try the below formula with cse
>
> =SUM((1/COUNTIFS(A2:A11,A2:A11,B2:B11,B2:B11))*(B2:B11))
>
> On Wed, Oct 3, 2012 at 10:57 AM, Pravin Gunjal
> > wrote:
>
>> *Kuldeep, This is not working...*
Hi Pravin,
Pls Note below steps what I did.
in Column C
=A2&B2drag it up to C10
in Column D
=COUNTIF($C$2:$C2,C2) Drag it up to D10
Now in Cell B11 I Wrote : =SUM((B2:B11)*(D2:D11=1)) with Ctrl+Shift+Enter
Regards
Prince
On Wednesday, October 3, 2012 10:38:03 AM UTC+5:30, Pravin Gunjal w
Hi Ankur,
Please Paste this formula in G1 and modify it as per your requirment.
IF(AND(PRODUCT((B1:B4=B1)*1),(SUM(F2:F4)=F1),(OR(C2:C4={"E","F","A"}))),"Yes","No")
with Ctrl+Shift+Enter
Regards
Prince
On Tuesday, October 2, 2012 12:19:37 AM UTC+5:30, ankur wrote:
>
> Hi All,
>
> I seek some
Congrats Rajan.Keep it Up
On Tuesday, October 2, 2012 9:04:33 PM UTC+5:30, Ayush Jain wrote:
>
> Dear members,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> Sep'12. He has posted 137 posts in last month and helped forum members
> through his excel expertise.
> I
Hi Friend,
I hope this will help you.
Private Sub FolderRead(ByRef myFolder)
Dim countf As String
countf = 0
For Each f In myFolder.Files
Var = f.Path
If Right(f.Name, 4) = ".pdf" Or Right(f.Name, 4) = ".tif" Then
i = i + 1
ActiveSheet.Hyperlinks.Add Anchor:=Range("A"
Hi Sagar.
I guess that automatic update option is set to manual in your case. So you
need not to do anything special just follow this step.
Option Button->excel option->formula ->Select Automatic in calculation
option.
Regards
Prince
On Tuesday, September 25, 2012 3:50:48 PM UTC+5:30, ca_k...
Hi Ahmed,
Can you please tell how the Hijri date is calculated from a normal date.
regards
Prince
On Tuesday, September 25, 2012 3:28:02 PM UTC+5:30, kothakota wrote:
>
> Dear All,
>
> Please find attach the Raw Data sheet from which I need to convert a
> Gregorian Date to a Hijri Date and pu
Hi Rajeyssh,
Please use this formula for formating
=VALUE($E6)>VALUE($F6)
as i saw u have wrriten $E$6>$F6 which correct but it not working because
all the values in column F is text type so first convert it into Value then
compare it.
regards
Prince
On Tuesday, September 25, 2012 3:19
http://www.excelfox.com/forum/f5/
On Monday, September 24, 2012 10:30:15 PM UTC+5:30, Rawat wrote:
>
> Sorry for OFF TOPIC post.
>
> Please suggest to me a similar active group for MS WORD Macros issues
> that I have to ask?
>
> Thanks.
> --
> Rawat
>
--
Join official facebook page of this
Hi Hilary please use this formula hope this will helpe u.
=MAX(INDEX('Monthly End Prices'!C2:AK169,,MATCH(Sheet2!B1,'Monthly End
Prices'!C1:AK1,0)))
Regards
Prince dueby
On Thursday, September 20, 2012 9:28:51 PM UTC+5:30, hilary lomotey wrote:
>
> Hello Experts,
>
> i need a formula to cal
Hi Ayush,
Please bane this user.
regards
Prince
On Sunday, September 23, 2012 1:36:45 PM UTC+5:30, Louis Ranjhan wrote:
>
> SLIM AND EYE CATCHING BODY
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violat
Hi Ram Gopal,
Please see these links these will help you to learn.
http://home.pacbell.net/beban http://excel.tips.net
http://www.andrewsexceltips.net/ http://www.andypope.info/
http://akoul.blogspot.com http://www.ashishmathur.com
http://www.discussexcel.com http://members.aol.
Hi Ayush Please Bane this user.
On Wednesday, September 19, 2012 7:40:44 PM UTC+5:30, himanshu diverselynx
wrote:
>
> Hi,
>
>
>
>
>
> Hope you are doing great !!
>
>
>
> * *
>
> *Title – **J2EE Technical Lead*
>
> *Location - NYC
> Duration- 12 months*
>
> *Compensation – Best in
rr),1)=varArr
End With
End Sub
Regards
Prince
On Tuesday, September 18, 2012 12:21:14 PM UTC+5:30, Prince Dubey wrote:
>
>
> Hi Dik,
>
> just use
>
> sub SortData(rngData, as range,intCol as integer)
>
> end sub
>
>
> On Tuesday, September 18, 2012 3:
Hi Dik,
just use
sub SortData(rngData, as range,intCol as integer)
end sub
On Tuesday, September 18, 2012 3:31:47 AM UTC+5:30, Dick wrote:
>
> Heed help is sorting hidden rows. Is there a vb macro code that someone
> can help me with to sort reguardless if the rows are hidden or not.Thanks
Hi Putta Madaiah,
Do u want to highlight the cells or Columns or Rows in which ur intended
string found ?
regards
Prince.
On Monday, September 17, 2012 9:03:55 PM UTC+5:30, Putta Madaiah wrote:
>
> Hi Ex(cel)perts,
>
> I am in need of a macro based search tool in Excel 2010.
>
> If I type
Hi Sundarvelan
i hope this will help u .
=LEFT(C32,FIND({"1","2","3","4","5","6","7","8","9","0"},C32,1)-1)
Regards
Prince
On Monday, September 17, 2012 2:47:48 PM UTC+5:30, Sundarvelan wrote:
>
> Hi Friednds,
>
> Please help me to extract only text from alphanumeric word for example
>
>
Hi Boreh
use this =VALUE(LEFT(A2,LEN(A2)-1))
Enjoy
Regards
prince
On Monday, September 17, 2012 12:42:09 PM UTC+5:30, kip wrote:
>
> Dear members,
> I have an excel sheet with numbers, but they contain a non numeral
> character at the end and i can not therefore sort nor do any mathema
; *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Vabz
> *Sent:* 16 September 2012 11:17
> *To:* excel-...@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Highlight Worked Cells only if the
> Employee has worked in both areas
>
>
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 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 Rashid,
Please see the attachment, Hope this will help you.
Note : For testing the solution first set any other color for the cell
where the your specified criteria matched and then press the button
Highlight.
regards
prince
On Saturday, 15 September 2012 17:22:57 UTC+5:30, prkhan56 wrote:
Hi Santosh,
Hope this UDF function can help you
Public Function getNextWorkingDate(startDate As String, Days As Integer,
ParamArray fld() As Variant) As String
Dim strStartDate As String
Dim strEndDate As String
Dim intCtr As Integer
Dim intCtr1 As
Hi Shrini,
You need not to do anything just follow below mentioned steps
1: right click on the cell having Zero in it.
2: Choose format cell
3:Select Custome In Category Section
4:Type *;;; (Three semicolons)* under Type Hading
5:Click Ok Thats It
Ragards
Prince .
On Thursday, September 13, 201
Hi Shrini.
Please follow steps mentioned.
1: right click on the cell having zero in it.
2:Select format cells
3:Select Custom In category section
4:Type (*;;;*) three semicolons under type hading.
Thats it.
Regards
Prince
On Thursday, September 13, 2012 12:40:13 PM UTC+5:30, shrini wrote:
>
>
Hi Shrini,
Do the following
1 : Right click on the cell
2: Select format cells
3: Select *Custom *under Category section
4: Type (*;;;*) Three Semi Colons under type heading and Click OK
thats it.
regards
Prince
On Thursday, September 13, 2012 12:40:13 PM UTC+5:30, shrini wrote:
>
> Dear Al
Hi Amit,
Pls see the attachment
regards
prince
On Thursday, September 13, 2012 5:37:34 PM UTC+5:30, Amit Desai (MERU)
wrote:
>
> Please let me know if we have an easier way for sorting data all
> together in all sheet having common column heads.
>
>
>
> Best Regards,
>
> Amit
>
>
>
> --
Hi Amar,
In excel you can insert any image file and by using VBA you can make their
visibility false and true so the same thing happening in this file.
regards
prince
On Thursday, September 13, 2012 1:20:43 PM UTC+5:30, amar takale wrote:
>
> Hi All,
> I found above file on web. But I cant und
Means ??
regards
prince
On Thursday, September 13, 2012 7:40:41 PM UTC+5:30, Hemant wrote:
>
> Hi Group,
>
>
> I want to know how Circle Invalid function works in excel and vba.
>
>
> Regards,
> Hemant.
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
ptions (Alt+T+O)
> --> Click on Advanced --> Display options for this worksheets --> remove
> the tick mark from : Show a zero in cells that have zero value.
>
> Regards
> Pravin Gunjal.
>
> On Thu, Sep 13, 2012 at 3:13 PM, Prince Dubey
>
> > wrote:
>
>
Hi Shrini,
Do the following
1 : Right click on the cell
2: Select format cells
3: Select Custom under Category section
4: Type (;;;) Three Semi Colons under type heading and Click OK
thats it.
On Thursday, 13 September 2012 12:40:13 UTC+5:30, shrini wrote:
>
> Dear All
>
> If i enter 0(zero
Hi Jeet,
Please use below formula hope this will helpe you.
=SUM(SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=12)),SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=13)))
use it with Ctr+Shift+Enter
Regards
Prince
On Wednesday, September 12, 2012 11:52:11 PM UTC+5:30, jeet
Hi Vinay.
Pls follow below mentioned steps.
1: download customUI editor And install it in ur system.
2: open ur workbook in ur UI editor.
3:Put XML from following Link(
http://msdn.microsoft.com/en-us/library/office/dd756403(v=office.12).aspx)
Code into ur Editor.
4:Click on Validate XML
thats
Hi Sagar,
I think stock management criteria for several firms or companies could be
different so pleas explain requirements (functionality as u require) to be
in ur macro.
regards
prince
On Tuesday, September 11, 2012 11:04:42 AM UTC+5:30, ca_k...@yahoo.co.in
wrote:
>
> Dear all,
>
> Any
Hi Pravesh,
Can you plz express ur idea about flipiing the chart in more general trems,
I mean what do mean by flipping the chart.
regards
prince
On Tuesday, September 11, 2012 9:30:32 PM UTC+5:30, PRAVESH KUMAR wrote:
>
> Hi Team,
>
> Could you help me to make Flip Chart through VBA Coding.
Hi Mangesh,
Try this hope tghis will help you.
=TRIM(MID(SUBSTITUTE($A$1,",",REPT("
",LEN($A$1))),((COLUMNS($A$1:A1)-1)*LEN($A$1))+1,LEN($A$1)))
paste this in B2 then press f2 select B2 to D2 and CSE
regards
Prince
On Monday, September 10, 2012 4:34:33 PM UTC+5:30, Mangesh wrote:
>
>
Hi Vijay,
I hope you got ur answer as David explained. Those are the best way to
learn new things of VBA.
regards
prince
On Saturday, September 8, 2012 3:17:44 PM UTC+5:30, Vijay Aggarwal wrote:
>
> Hello Excel VBA Gurus!!!
>
> My name is Vijay and currently I am working in MIS Team of a MNC in
Nice formula Don
regards
prince
On Friday, August 31, 2012 6:05:54 PM UTC+5:30, Kuldeep Singh wrote:
>
>
> Hi Experts,
>
> I want to required Revenue started from Date.
>
>
> Regards,
> Kuldeep Singh
> Phone.: +91-120-4763789, Extn.: 789
> naukri...@gmail.com || www.naukri.com
> *Please* *Consid
Hi Sujit,
Please just copy and paste the following code and call this function on
worksheet As * SpellNumber(Number) *
*
*
*
*
*
Option Explicit
'Main Function
Function SpellNumber(ByVal MyNumber)
Dim Dollars, Cents, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2)
Hi Harshad,
Please see the attachment hope this will help you.
regards
prince
On Sunday, September 9, 2012 12:19:35 PM UTC+5:30, harshad shukla wrote:
>
> dear all,
> I had a query where in i had to sum the values of cell based on cell
> colour.that is to add all
> numbers of a row whose cell
Hi Sundarvelan,
Just paste below formulas In columns I and J and drag this up to i20 and j20
*=INDEX($B$1:$F$20,MATCH(K2,$D$1:$D$20,0),1) in I2 Circle*
*
=INDEX($B$1:$F$20,MATCH(K2,$D$1:$D$20,0),2) in J2 Area
Regards
Prince
*
On Thursday, September 6, 2012 12:37:06 PM UTC+5:30, Sundar
Hi Jeet,
I did'nt get your query or the selection criteria for the desire
solution.So pls explain little more about the problem.
regards
prince
regards
prince
On Thursday, September 6, 2012 10:28:42 AM UTC+5:30, jeet singh wrote:
>
>
>
> Dear All,
>
> plz find the attachment and help
>
>
Dear vinay this is not the place where job posting can be done so pls
follow the rules of forum.
On Thursday, September 6, 2012 7:29:03 PM UTC+5:30, Vinay Kumar wrote:
>
>
>
> *Req: Sun IDM Developer*
>
> *Location: NY*
>
> *Duration 12 months*
>
>
>
> *Required Skills Include
Hi Rajan,
I m agree with you.
On Thursday, September 6, 2012 8:11:31 PM UTC+5:30, Rajan_Verma wrote:
>
> Although you can know VBA Project is lock or unlock but you can not lock
> or
> unlock VBProject by Code
>
>
> Regards
> Rajan verma
> +91 7838100659 [IM-Gtalk]
>
>
> -Original Messa
Hi sandeep,
i hope scope of ur function or sub is private, so please make it public. If
it does not work then pls share the ur workbook with us.
regards
Prince
On Thursday, September 6, 2012 4:15:13 PM UTC+5:30, sandeep chhajer wrote:
> Dear all,
>
> I have made a UDF (formula) in personal.
Hi Maksood,
Can you pls let us know what kind of tool do you want.I mean what kind of
functionalities do you want in your tool.
Regards
Prince
On Tuesday, September 4, 2012 11:47:03 PM UTC+5:30, maksood alam wrote:
> Hi Gusy,
>
>
> Please provide some website from where i can downloa
Congrats Noorain sir.
On Sunday, September 2, 2012 10:33:02 AM UTC+5:30, Ayush Jain wrote:
> Dear members,
>
> Once again, Noorain Ansari has been selected as 'Most Helpful Member' for
> the month of Aug'12. He has posted 111 posts in August 2012 and helped many
> forum members through his e
I have got it logic(:
Regards
Prince
On Tuesday, September 4, 2012 10:20:46 AM UTC+5:30, Bhaity wrote:
> Dearest All,
>
> Lets have a break for a while :-
>
> Minder Reader is attached with. Actually the reader seems to be very
> creative, but it is built in logical way. Pl
Hi Mangesh
You can use an sddin to simplify your task for example you can use SQLodbc (
*http://sqlodbc.t35.com* <http://sqlodbc.t35.com/>)
=sql.execute("CONNECTION STRING";"YOUR SQL CODE");
hope this will help you
regards
prince dubey.
On Monday, September 3
try this and drag the same at the end of ur range with criteria
=SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<"&O15)
regards
prince
On Monday, September 3, 2012 5:17:27 PM UTC+5:30, rambo wrote:
> Dear all,
>
>
> --
> Regards
> Rambabu. G
>
--
Join official facebook page of t
Hi Amar,
Please paste this formula H3 and Drag it to H6 this will give ur desire
result.
=RIGHT(D3,LEN(D3)-(FIND(")",D3,1)+1))
Regards
Prince
On Tuesday, September 4, 2012 2:01:19 PM UTC+5:30, amar takale wrote:
>
>
--
Join official facebook page of this forum @
https://www.facebook
Hi Rakesh,
Plz Use this Hope this will Help You.
SUMIF(Sheet1!$B$2:$B$18,Sheet2!A2,Sheet1!$D$2:$D$18)
Regards
Prince
On Monday, September 3, 2012 1:01:07 PM UTC+5:30, rakesh sharma wrote:
> Hi Experts,
>
> I need the actual remit amt agnst tracking on sheet2 when data was found
> repeated
Hi Pravin,
Please use this hope this help you
TEXT(A1 ,"-")
regards,
Prince
On Saturday, September 1, 2012 12:58:23 PM UTC+5:30, Pravin Gunjal wrote:
> Dear Friends,
>
> I have attached an excel file for the subject mentioned above.
>
> In which there is column having full date in th
>
> [image: Inline image 1]
>
> 2. If I type *52.06** *then we should get the following result...
>
> [image: Inline image 2]
>
> Hope the requirement is understood by you. Kindly look in to this and do
> the needful. Thank you.
>
> *REGARDS,*
> *PRAVIN GUNJ
Hi Praveen,
Please see the attachment hope this will help you.
regards
prince
On Monday, August 27, 2012 3:02:48 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hello Friends,
>
> Need a help on the following issue.
>
> 1. I am having a file containing 318 products / rates in it. (file is
> attached f
Hi Dick,
Hope this help you.
Sub Test()
Dim rng As Range
Dim ClAs Range
With ThisWorkbook.Worksheets("Sheet1")
Set rng = .Range("H1:H" & .Range("H" & .Rows.Count).End(xlUp).Row)
For Each Cl In rng
If Cl.Value > 1 Then
Cl.Interior.Color = vbYellow
Cl.Ent
Hi LJ,
Do you want the result in hrs OR in days, because ur format is in mm-dd-yy
hh:mm:ss. So please explain ur question with an example.
regards
prince
On Monday, August 27, 2012 7:59:11 PM UTC+5:30, LJ wrote:
>
> Greetings,
>
> I am trying to figure out a formula that will give me the amo
Very Nice and Good work Rajan
Regards
prince
On Wednesday, August 22, 2012 7:32:24 PM UTC+5:30, Rajan_Verma wrote:
>
> * *
>
> *Hi Group,*
>
> * *
>
> *Just sharing hook chart , see the attached sheet*
>
> * *
>
> * *
>
> **
>
> * *
>
> *
> any comment and suggestion are welcome ,*
>
> *You can a
Please see the attachment
regards
prince
On Thursday, August 16, 2012 3:39:08 PM UTC+5:30, amar takale wrote:
>
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread
Hi Amit,
I thinks if your data is too large then please try it operate by using
Arrays and dictionary objects In VBA.
regards
prince
On Wednesday, August 15, 2012 7:18:41 PM UTC+5:30, Amit Desai (MERU) wrote:
>
> Dear Friends,
>
>
>
> I need to work on huge data in excel 2007. Whenever I u
Hi Hilary,
i please try following step hop it will work for you.
1. Save ur work book in 2003-97 format
2.Go to developer tab->In ActiveX Control select last icon (right bottom
most(more control))->Add window media player->drop it on sheet
3.Click on design mode
4. Select the property of window
Hi Group,
I have a project which is running fine on my system with XP OS but the same
project giving error of "Out of Memory 7" on other system with XP platform.
I am using VBA and Acess as data source. I tried my level best to track
the source of error but not able to find it.So can you pls
Hi Ayush Pls ban this user.
On Monday, 13 August 2012 21:48:23 UTC+5:30, sudheer sudheer wrote:
>
> *Hi*
>
> *Need*
>
> *Role: CRM Administrator (Sales force)*
>
> *Duration: 1 Year*
>
> *Location: Austin, TX*
>
> *Job Specific *
>
> *Job Specific Required education & experience*
>
> · High
Hi Divaker,
Can you plz share ur work book with group.
regards
prince
On Thursday, 9 August 2012 19:17:50 UTC+5:30, Divaker Pandey wrote:
>
> Hi Expert,
>
> can any one help me to show last available date in chart -xaxis range.
>
>
> Divaker
>
--
Join official facebook page of this forum @
h
Thanks Sam , it is useful for me also.
prince
On Monday, August 6, 2012 10:08:09 PM UTC+5:30, Sam Mathai Chacko wrote:
>
> =HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1)
>
> Regards
>
> Sam Mathai Chacko
>
> On Mon, Aug 6, 2012 at 9:41 PM, ashish koul
> > wrote:
>
>> =HYPERLINK("#'"&SUBSTITU
Hi Pravin,
Please go officebutton->excel option->advanced->Display option for this
workbook->All (option ) select this option will allow you to insert row
without any error.
regards
prince
On Thursday, August 9, 2012 6:26:55 PM UTC+5:30, Pravin Gunjal wrote:
>
>
> *With regards,
>
> **Prav
Hi Pawel,
please see the attachment.
regards
prince
On Wednesday, August 8, 2012 11:15:30 PM UTC+5:30, lupinskip wrote:
>
> Hi All,
>
> I'm looking for formula that will be checking cell base on the condition
> that last 8 digits will be match, with 8 digits from different cell. Pls
> see a
hi muneer,
please see the attachment.
prince
On Wednesday, August 8, 2012 5:34:03 PM UTC+5:30, Mohammed Muneer wrote:
>
> Dear Group,
>
>
>
> Make bold the data relevant in the below rows that follows the yellow
> highlighted in cell A1.
>
>
>
>
>
>
>
> Regards,
>
> Muneer,
>
Hi Muneer,
please see the attachment hope this will help you.
regards
prince
On Wednesday, August 8, 2012 6:50:06 PM UTC+5:30, Mohammed Muneer wrote:`
>
> Regards,
>
> Muneer,
>
> CC….
>
>
>
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexce
Hi Amar,
I think it depends on the creativity of a person you should search on
google for this.
regards
prince
On Tuesday, August 7, 2012 7:26:56 PM UTC+5:30, amar takale wrote:
>
> All Experts
> Can anybody give me index sheet example where index sheet is fantastic
> presentation view In spre
Hi JP
Please see the attachment.
regards
prince
On Tuesday, August 7, 2012 2:30:26 PM UTC+5:30, Jayaprakash S wrote:
>
> Dear Experts,
>
> Good Noon.
>
> Need help in auto filling of Colours to the shapes as well
> attached excel sheet for more information.
>
> Kindly Help & advise.
>
>
very well explained Rajan
On Wednesday, August 1, 2012 10:46:27 AM UTC+5:30, vijayajith VA wrote:
>
> Hi Gurus,
>
> Please could you explain what is the use of Public & public const in vba
> macros.
>
> could you provide me one simple example...
>
> Thanks
>
>
>
>
>
>
--
FORUM RULES (986+
Hi Sam,
Nice Answer. I wanted to ask this question before well doesn't matter to
me, I got my answer.
regards
Prince
On Friday, August 3, 2012 9:34:10 PM UTC+5:30, Sam Mathai Chacko wrote:
>
> Trace Precendents and Trace Error is different from each other literally
> as it sounds. For any sin
Gys please don't post anything that is related with job posting.
On Friday, August 3, 2012 10:37:55 PM UTC+5:30, NOORAIN ANSARI wrote:
>
> Dear andrew,
>
> Job posting is ban here.
> Sent from BlackBerry® on Airtel
> --
> *From: * Andrew Thomas
> *Sender: * excel-macro
hi Kuldeep'
You can see my thread about the areas function that i had started on 29 of
july.
regards
prince
On Tuesday, 31 July 2012 10:05:28 UTC+5:30, Kuldeep Singh wrote:
>
>
> Hi Experts,
>
> Please tell me more about Areas Function with example. and how to use in
> excel workbook.
>
> Reg
l return 0.
- If *value* is an error, the error value is returned.
- For all other *value*s, the N function will return 0.
for example:
=n(35)=35
=n("hi")=0
Hope this will help you
regards
Prince dubey
On Tuesday, 31 July 2012 21:54:59 UTC+5:30, Kuldeep Singh wrote:
>
>
Hi Sam,
Thanks for your help .As i saw the result i guess that Areas property
return cluster of range when there is a range created by using union
function.
regards
prince
On Sunday, 29 July 2012 00:28:46 UTC+5:30, Prince Dubey wrote:
>
> Hi All,
>
>
> I want to know m
nds on 3,4 and 10 ,11 nov.
And also pls note:
Dates should be entered by using the DATE function
A positive value for days yields a future date; a negative value yields a
past date.
Prince dubey
Hope this will help you .
Regards
On Sunday, 29 July 2012 13:33:42 UTC+5:30, vic kumar wr
it returned 1 .
regards
On Sunday, 29 July 2012 00:28:46 UTC+5:30, Prince Dubey wrote:
>
> Hi All,
>
>
> I want to know more about Areas property of the range object,
>
> If I write: Range("A1").Areas(1) it return text inside that range but i
> m not abl
;).Areas.Creator
or range("A1").Areas.Parent , I m not able understand these.
Actually i m confused about these statements because i was expecting that
areas will return Areas ie # on of cells in that range, But it is not in
actual.
Prince Dubey.
--
FORUM RULES (986+ members alrea
Hi Indrajit,
I thing this site will help you
http://www.ozgrid.com/
regards
prince dubey
On Wednesday, July 18, 2012 3:09:11 AM UTC+5:30, Bullet wrote:
>
> Hi All,
>
> Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND, MATCH,
> OFFSET functions.
>
&
Hi Santosh,
Please refer attach sheet it may help you.
Regards
Prince dubey
On Monday, 16 July 2012 14:52:01 UTC+5:30, santosh wrote:
>
> Hi Group,
>
> I want the list of all the sheet names available or to created in sheet1
> automatically via formula of a workbook *
Hi Pawel,
In case of conditional formatting we can not refer other sheet. So for this
problem you can use macro.
regards
prince dubey.
On Monday, 16 July 2012 20:08:57 UTC+5:30, lupinskip wrote:
>
> Hi All,
> I'd like to ask you for favour. I have an issue with copy of the
Hi Rajesh,
You Can Use NPV Function of the excel, You Need not to do anything special
just type =NPV(rate,value)
regards
prince
On Saturday, 14 July 2012 20:40:16 UTC+5:30, rajasekaran wrote:
>
> How to Calculate NPV using Macros
--
FORUM RULES (986+ members already BANNED for violation
hi Prashant,
Use this
=INDEX(A2:A4,MATCH(TRUE,LEN(A2:A4)<>0,0),1) with Ctrl+shift+enter
regards
prince dubey
On Thursday, 12 July 2012 16:50:22 UTC+5:30, ppawle.excel wrote:
>
> Dear All,
>
> Need a formula for getting first text in the Range, in particular cell ,
>
Hi Mothi,
Please attach your workbook, your question is not clear.
regards
prince
On Thursday, 12 July 2012 20:48:49 UTC+5:30, mothi wrote:
>
> Dear any one
>
> I am using sheet1 worksheet column a to n , Column width is differents
> based on datas. same data format different places up 20 she
Hi Ann,
Can you please explain bit more about your issue.As we are not able to
understand your Issue.
Do you want to copy data from active cell or anything else ?
regards
Prince dubey.
On Tuesday, July 10, 2012 3:21:50 PM UTC+5:30, an wrote:
>
>
> Dear experts,
>
> please help
Hi Muneer,
Please see the attachment.
regards
Prince dubey.
On Tuesday, July 10, 2012 7:55:34 PM UTC+5:30, Mohammed Muneer wrote:
>
>
>
> Hi! Everybody,
>
> Dear Group,
>
>
>
> I want to extract a word from the sentence in cell beside.
>
.Count).End(xlUp).Row)
intNext = Application.WorksheetFunction.Max(rng)
rng.Offset(1) = intNext + 1
End With
End Sub
Regards
Prince dubey.
On Tuesday, July 10, 2012 7:12:00 PM UTC+5:30, Hemant wrote:
>
> Hi Group,
>
> I am trying to get a automatically generate a Num
Congrats rajan.
regards
prince dubey
On Wednesday, 4 July 2012 21:46:48 UTC+5:30, Ayush Jain wrote:
>
> Hello Everyone,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> June'2012. This is third time in row. :)
> He has posted 149 p
Hi Deba,
I found your solution working fine.
regards
prince
9891472849
On Saturday, 7 July 2012 12:00:10 UTC+5:30, Bhaity wrote:
>
> Hi Karan,
>
> PFA...
>
> Use this formula for unique extraction:
>
> =IFERROR(INDEX($A$1:$A$11,MATCH(0,COUNTIF($C$2:C2,$A$1:$A$11),0)),"")
>
> And for counti
Hi Sreejit,
Please see the attachment i hope this will help you.
regards
prince
9891472849
On Sunday, 8 July 2012 20:55:24 UTC+5:30, Sreejith K. V wrote:
>
> Hi Team,
>
> Can someone please help me with the attached excel sheet.
>
> Regards
> Sreejith
>
--
FORUM RULES (986+ members already
Hi B Sharma,
Please See the Attachment, hope this will help you.
Regards
Prince
On Friday, 6 July 2012 17:15:20 UTC+5:30, B Sharma wrote:
>
> Dear Excel Experts,
>
> I have a protected data sheet, where I want to insert row where the cursor
> is selected.
>
> I need a VBA code who will do the
Hi Lakshman,
I think you should copy or Move your each sheets into a new work book this
help you to know the size of each sheets in your workbook.
hope this will help you.
regards
prince
On Tuesday, 3 July 2012 13:02:48 UTC+5:30, lakshm...@yahoo.com wrote:
>
>
> Dear Expert,
> Is there an
1 - 100 of 117 matches
Mail list logo
