Please help...
On Monday, September 24, 2018 at 5:31:49 PM UTC+5:30, vikas khen wrote:
>
> Hi All,
>
>
>
> Kindly find the attached two sheets, based on the same I need Conditional
> formatting formula to highlight the cell value in color it the given
> criteria matches. I have mentioned the
Put the below formula in D1.
=IF(A1>B1,"Buy","Sell")
Since you have only two checks to be done, no need of nesting loop here. (
i mean if within if).
Thanks & Regards,
Prabhu R
On 17 February 2018 at 06:08, who wrote:
> Maybe this will work for you?
>
Maybe this will work for you?
=IF(A1>B1,"Buy1",IF(A1 I have a table where data changes continously (stock market data). I want
> to apply IF formula. please understand with given example.
the formula seems to work as it is designed.So what kind of help do you need?
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever
--
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) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Hi Paul,
I am getting error message mentioning the cells cannot be pasted as the
size and shape is not same.
Regards,
Kaushik
On Tuesday, May 23, 2017 at 11:32:58 PM UTC+5:30, KAUSHIK SAVLA wrote:
>
> Hi Team,
>
> I am trying to do below in an excel. You can assume there are 60
> worksheets
Thanks *Suresh.*
It's working as required... :)
On Monday, February 6, 2017 at 4:24:42 PM UTC+5:30, सचिन शर्मा wrote:
>
> Dear Experts,
>
> Please help to resolve below requirement.
>
> File attached for reference.
>
>
> *Numbers .: 1,054,265*
>
> *Result Shows .: *Ten Lakh Fifty Four
Hi *Sachin*,
As you said, I have made changes in the file through formulas
Please check & let me know, If any Changes.
*Thanks & Regards,*
*Suresh Kumar.B*
*Mobile #9894585740*
On Friday, February 17, 2017 at 10:53:19 AM UTC+5:30, सचिन शर्मा wrote:
>
> Thanks Suresh,
>
> It's working and
Thanks Suresh,
It's working and shows "*and*" before last 2 "00" digits.
but, if value comes less then 100 then "*Hundred And*" still visible (Ex.:
99 = *Hundred and Ninety Nine Rupees Only*)
On Monday, February 6, 2017 at 4:24:42 PM UTC+5:30, सचिन शर्मा wrote:
>
> Dear Experts,
>
> Please
Dear Sachin,
Herewith i have attached the completed file as you requested.
Please Check & let me know, If you have any questions.
Thanks,
Suresh Kumar.B
Mobile # 9894585740
On Monday, February 6, 2017 at 4:24:42 PM UTC+5:30, सचिन शर्मा wrote:
>
> Dear Experts,
>
> Please help to resolve
This might help brother
=SUM(TRANSPOSE($C$2:$F$2)*$L$2:$L$5)
ctr+shift+enter
regards
Abhinav
On Friday, December 2, 2016 at 11:35:36 AM UTC+5:30, Deepak Rawat wrote:
>
> Hi,
>
> I need to calculate final billing product of several product with
> respective MRP.
>
> sample file is attached.
>
>
Yes, its working for me,
can you please share the screenshot.
thanks
--
On Sat, Aug 27, 2016 at 10:48 PM, Manju Keerthi
wrote:
> Was it working fine for you? i am getting error in the below two line
> (error #1044) so, Else part "Range("b2").Validation.Delete" is not
>
Was it working fine for you? i am getting error in the below two line
(error #1044) so, Else part "Range("b2").Validation.Delete" is not working.
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween,
Try enclosed one.
--
On Sat, Aug 27, 2016 at 10:01 PM, Manju Keerthi
wrote:
> Thank you so much. This helped me a lot:-)
>
> Is there any option to disappear the dropdown when user does not have any
> value in column B. instead of disable the drop down in the column B.
>
Thank you so much. This helped me a lot:-)
Is there any option to disappear the dropdown when user does not have any
value in column B. instead of disable the drop down in the column B.
once again Thanks a lot :-)
Keerthi
On Saturday, August 27, 2016 at 11:33:50 AM UTC+5:30, Manju Keerthi
Share your sheet otherwise its not possible what the other variables
holds Position ?? Player ??
Regards :- Mandeep baluja
'https://www.facebook.com/groups/825221420889809/
'https://www.linkedin.com/in/mandeep-baluja-b777bb88
On Friday, May 13, 2016 at 7:28:01 AM UTC+5:30, Jaime Richmond
can you send me a sample file directly?That way I can try out some things
without spending hours building a test file that doesn't look anything at all
like what you have!
You can send it directly to:schreiner_p...@att.net
Paul-
“Do all the good you can,
Yes, can you pls suggest the alternative code.
Idea is when comboboxes are empty then it should run only on dates.
Cheers
Karthik
On Tuesday, 29 March 2016 20:01:03 UTC+5:30, Paul Schreiner wrote:
>
> Ah...
> I think maybe we should rethink the logic here.
> In your statement:
> Set rngD =
Ah... I think maybe we should rethink the logic here.In your statement:Set
rngD = wshD.Range("G:G").Find(What:=Me.ComboBox1.Value, Lookat:=xlWhole)if
Me.ComboBox1.Value is empty, you're looking in column G for "nothing".Does the
.Find method return an empty range? or a range of which column G
Thanks Paul for your response.Here is the complete macro for better
understanding.
Sub Fetch_Click()
Dim wshD As Worksheet
Dim wshP As Worksheet
Dim rngD As Range
Dim rngP As Range
Dim r As Long
Dim m As Long
Dim n As Integer
Dim rngD2 As Range
Hi Maju,,,i think if you provide some example sheet, you will get your
answer very soon.
On Wednesday, March 9, 2016 at 8:23:53 PM UTC+5:30, Maju wrote:
>
> Hello all!
>
>
>
> Please I need macro help with the below in red:
>
> What is the best way to achieve this without using the
I came up with below but I need a better efficient way of writing it. I
don't think it is the right way to do for each statement all the time.
Dim CurCell As Object
Dim CurCell2 As Object
Dim CurCell3 As Object
Dim CurCell4 As Object
Dim
Sub Solution()
Range("A7").Select
Do Until IsEmpty(ActiveCell)
ActiveCell.Copy
ActiveCell.Offset(0, 1).Select
ActiveCell.PasteSpecial xlPasteAll
ActiveCell.NumberFormat = "MMM-YY"
ActiveCell.Offset(1, -1).Select
Loop
End Sub
On Sunday, January 10, 2016 at 8:51:53 PM UTC+5:30, Pankaj Sharma
Hi Mandeep,
Sorry for the confusion.
Final score is 100 if all are Yes.
I need the formula in Colum "I" for Score.(Distribution of Score in case of
"NA" should be calculated here.)
Data in K:P are the values for "Yes" & "No" of data in B:H.
PFA updated sheet. The difference in headers are typo
>
> Hey check this out !!
>>
>
Regards,
Mandeep baluja
--
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) Use concise, accurate thread
Hi Mandeep,
Please refer to the comment in attached sheet.
I hope it would get clear now. :)
On Thursday, January 7, 2016 at 2:06:11 PM UTC+5:30, Mandeep Baluja wrote:
>
> Hey SG,
>
> Correct me if I am wrong !!
> 1)If Parameter M(Fatal) is No, then total score would be 0 Formula should
> be
Hey SG,
It's very difficult to understand your query what you wish or what you want
to achieve as may be we both are using different terminology or might be
explanation. Sorry to say Hope someone will help you with these given below
instructions as I am not able to matchup the aim.
You
>
> Check this out,Easily achieved with formula
> {=IFERROR(INDEX(Raw!$D$2:$H$85,MATCH('WAVE 1'!$A4&'WAVE 1'!B$2&'WAVE
> 1'!$A$2,Raw!$A$2:$A$85!$B$2:$B$85!$C$2:$C$85,0),MATCH(B$3,Raw!$D$1:$H$1,0)),0)}
>
Regards,
Mandeep baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Thanx a lot mandeep its working.
On Wednesday, August 5, 2015 at 1:05:03 PM UTC+5:30, Nasir Saikh wrote:
Hi,
Please help me out to split numbers from a cells if the numbers available
in the last then.
Example attached.
Thanks.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
;) Glad to help https://www.facebook.com/groups/825221420889809/
On Thursday, August 6, 2015 at 11:55:00 AM UTC+5:30, Nasir Saikh wrote:
Thanx a lot mandeep its working.
On Wednesday, August 5, 2015 at 1:05:03 PM UTC+5:30, Nasir Saikh wrote:
Hi,
Please help me out to split numbers from
What is the criteria for the best price Is it the min value from the price
column against a particular Item.??
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Monday, June 1, 2015 at
Yes, Minimum Value
On Mon, Jun 1, 2015 at 12:12 PM, Mandeep Baluja rockerna...@gmail.com
wrote:
What is the criteria for the best price Is it the min value from the price
column against a particular Item.??
Regards,
MandeepBaluja
Learningzmypassion.
Check this attachment !!
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Monday, June 1, 2015 at 10:07:52 AM UTC+5:30, TAWHID wrote:
Dear Experts,
Need little help here. Please have a look
Dear Vabz!
I can't find your last email. Plz send me your suggestion in this post.
I'll be thankful to your
Thanks
On Friday, December 26, 2014 11:19:38 PM UTC+5, MRafique Ujjan wrote:
Dear Experts!
I am facing problem during printing of payroll because it consists
more than 1000
Hello kamal,
check dis out .
Private Sub CommandButton1_Click()
Dim brand As Long
Dim invoice As Long
Dim cell As Range
brand = TextBox1.Value
invoice = TextBox2.Value
temp = brand invoice
Set ws1 = ActiveWorkbook.Sheets(1)
For Each cell In ws1.Range(a1, [a65535].End(xlUp))
If
Yes there is option in excel to split the data in seperate column as same
format of pdf .
On Sunday, October 19, 2014 6:48:36 PM UTC+5:30, Ujjwal Desai wrote:
Hello ,
I need your help with regards to the attached macro file.
I am trying to convert the pdf file to excel format but the
Hello ,
Awaiting for your help !.
Thanks,
Ujjwal
On Sunday, October 19, 2014 6:48:36 PM UTC+5:30, Ujjwal Desai wrote:
Hello ,
I need your help with regards to the attached macro file.
I am trying to convert the pdf file to excel format but the conversion is
not as expected.
Sorry I'm an excel noob, I don't understand what to do.
On a side note though, i was wondering what the formula would be if it was
just to find whether Cells(1, 1).Value exists in row B, and where it would
be. Also what would the formula for selecting the bottom row with a value
in it be?
Hi
You need to use count if formula to get what you want..in range you need to
specify both the column where probable value would be.
Refer file in my previous post with yellow colored range.
Cheers!!
On Sun, Jun 15, 2014 at 12:02 PM, Noah Shalii koukinom...@gmail.com wrote:
Sorry I'm an
Hi, thanks for the help.
However, this only seems to work with the set of values I provided as an
example.
i was wondering if there is a way it would work with any set of numbers I
add to the A column.
Thanks
On Sunday, June 15, 2014 2:09:39 AM UTC+9, Noah Shalii wrote:
Hi, I am in need of
Hi
Check yellow cells..
Cheers!!
On Sun, Jun 15, 2014 at 11:05 AM, Noah Shalii koukinom...@gmail.com wrote:
Hi, thanks for the help.
However, this only seems to work with the set of values I provided as an
example.
i was wondering if there is a way it would work with any set of numbers I
Hi Suyog Kulkarni,
See how build an Excel Add -In
http://www.fontstuff.com/vba/vbatut03.htm
Regards,
Basole
2014-04-05 1:22 GMT-03:00 Suyog Kulkarni nashi...@gmail.com:
Hi Basole,
It's working fine now following are the only problems remaining.
1. While creating macro, I have assigned
Hello All,
I made my first macro code. Kindly review. Now only problem remain is
instead of *Range(A1:I100), I want excel to choose last row last
column which contain text/value.*
PL help.
Regards,
Suyog
Below is my code
*Sub Format()*
' Format Macro
' Keyboard Shortcut: Ctrl+q
' This is
Hello All,
I made my first macro code. Kindly review. Now only problem remain is
instead of *Range(A1:I100), I want excel to choose last row last
column which contain text/value.*
PL help.
Regards,
Suyog
Below is my code
*Sub Format()*
' Format Macro
' Keyboard Shortcut: Ctrl+q
' This is
Hi, try this:
x = Cells(Rows.Count, A).End(xlUp).Row
y = Cells(x, Columns.Count).End(xlToLeft).Column
Range(A1: Cells(x, y).Address).Select
Regards,
Basole.
2014-04-04 11:17 GMT-03:00 Suyog Kulkarni nashi...@gmail.com:
Hello All,
I made my first macro code. Kindly review. Now only
Hi Basole,
It's working fine now following are the only problems remaining.
1. While creating macro, I have assigned ctrl+q shortcut which is not
working now
2. How can we save the code as Add In or can we add any buttom in
existing toolbar ? so I that I can share the same with my co-workers.
PG, Please share an example with some data!
regards,
Basole.
Em sexta-feira, 20 de dezembro de 2013 16h27min17s UTC-2, PG escreveu:
Hi,
I have a problem to solve here.
I have a master list of about 1000 records, which has Order ID, Customer
Name, Address, and Order Amount columns.
Hello Philip, I think this is not an appropriate environment to request
this kind of help!
regards,
Em terça-feira, 17 de dezembro de 2013 11h37min16s UTC-2, Philip escreveu:
Hope you get this on time, I made a trip to Ireland and my Bag was stolen
from me with my passport, cash and
$$ Re: Need help
Hello Philip, I think this is not an appropriate environment to request this
kind of help!
regards,
Em terça-feira, 17 de dezembro de 2013 11h37min16s UTC-2, Philip escreveu:
Hope you get this on time, I made a trip to Ireland and my Bag was stolen
from me with my
Hi Jocky, try this option in VBA.
Sub ImportTXT()
Dim DateTime As String '7 to 29
Dim CardHolder As String ' 33 to 49
Dim DoorZone As String ' 55 to 83
Dim Status As String ' 93 to 103
Dim nFile, rowTxt As String
nFile = C:\temp\1234.txt 'change according to the way of your TXT
Hi Prabhu,
I can help you if you can share data with me...
On Wednesday, September 18, 2013 8:59:41 AM UTC+5:30, prabhupink80 wrote:
Hi Experts,
i have historical pattern of last few month daywise daily offered. is
there possible to calculate the next month overall volume by using excel.
On Monday, July 15, 2013 10:03:35 PM UTC-4, bobsc...@yahoo.com wrote:
Hello,
I am using Excel 2003. I have attached a simple workbook which has two
worksheets. One worksheet is titled Scores and the other is Team Info.
On the team info worksheet, I have all the nfl teams listed in
Hi,
The following features can't be changed after a workbook is shared:
merged cells, conditional formats, data validation, charts, pictures,
objects including drawing objects, hyperlinks, scenarios, outlines,
subtotals, data tables, PivotTable reports, workbook and worksheet
protection, and
If you want to use VBA on a shared workbook I would recommend moveing the
code to an XLA
On Friday, June 7, 2013 10:45:10 PM UTC+5:30, maksood alam wrote:
Hi Guys,
I have workbook with codeing below
Private Sub Worksheet_Change(ByVal Target As Range)
*Sheets(MMPs).Unprotect 1234*
HiJust active macro and click to protect the sheet and unprotect the sheet and
see the macro, you will get the VBA code of your require.thanx
Date: Sun, 9 Jun 2013 00:15:38 -0700
From: v...@vabs.in
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Need help on worksheet protect
On Wednesday, March 27, 2013 9:30:05 AM UTC-6, gka...@gkading.com wrote:
I've created a simple module in excel 2007:
Function Sigmoid(t)
Sigmoid=1/(1+exp(-t))
End Function
The sigmoid function seems to work in formulas initially, but when file is
saved, closed, then reopened, the
Just try to replace your function with following.
public Function Sigmoid(t) as double
Sigmoid=1/(1+exp(-t))
End Function
regards
prince
On Thursday, March 28, 2013 4:37:23 AM UTC+5:30, gka...@gkading.com wrote:
On Wednesday, March 27, 2013 9:30:05 AM UTC-6, gka...@gkading.com wrote:
I've
Hi jocky Beta,
Please paste the this formula in Cell C6 With Ctrl+Shift+Enter
=IF(AND(($B$6=$A$13),SUM((C$4=$D$4:$H$4)*1)),$B$13,$B$14)
and C7
=IF(AND(($B$7=$A$15),SUM((C$4=$D$4:$H$4)*1)),$B$14,$B$13) with CSE
Regards
Prince
On Friday, January 4, 2013 4:59:03 PM UTC+5:30, jocky Beta wrote:
Hi Karthik,
I ]need some clarification about your queries.
1. As you have mentioned all the details, Do you want any macro that
extract all these details as you have listed into sheet.
Or do you want any excel formula or macro that extract summary from your
data that is in sheet it self.
Hi Mangesh,
Can you plase share your workbook with us ?
Regards
Prince
On Friday, November 9, 2012 12:09:18 AM UTC+5:30, Mangesh wrote:
Hi Friends,
I need your help.
I have Excel file containing some data. I have import this data to MS
Access 07 table by using Append query.
But when
fantastic Paul.
yes, all workbooks in only one folder. worked like a charm. Many thanks.
Mel
On Wednesday, October 31, 2012 12:49:45 PM UTC-4, Mel wrote:
I have a master spreadsheet with 5 tabs. On my master sheet (called
Master) - on the tab called 'Option Letter' I need to copy
Hi
Can you explain base for allocation, theer is no standard method that can
be assumed on the basisi if data given by you.
Rgds//Vabs
On Thursday, October 4, 2012 12:03:22 PM UTC+5:30, Vishwanath wrote:
Need help
Dear All,
I need your help in automatic some calculations in
Always show a before/after and the logic
On Thursday, October 4, 2012 1:33:22 AM UTC-5, Vishwanath wrote:
Need help
Dear All,
I need your help in automatic some calculations in spreadsheet.
I have data in excel as below;
It consists of 2 parts. first part is Expense statement and
Dear wabs,
Thanks for your reply.
The amount should be allocated equally over the period of time.
For example, for expenditure B, total expenditure of Rs. 1 has been
distributed prorata basis. It works out 3667 for 22 days in April, 5000 for
may(full month) and 1333 for for June . The period
can you attach the sample sheet
On Mon, Oct 8, 2012 at 9:53 PM, Vishwanath vishwana...@gmail.com wrote:
Dear wabs,
Thanks for your reply.
The amount should be allocated equally over the period of time.
For example, for expenditure B, total expenditure of Rs. 1 has been
distributed
Dear Ashishi,
Sending the the sample file.
thanks in advance for your cooperation.
On 8 October 2012 21:55, ashish koul koul.ash...@gmail.com wrote:
can you attach the sample sheet
On Mon, Oct 8, 2012 at 9:53 PM, Vishwanath vishwana...@gmail.com wrote:
Dear wabs,
Thanks for your reply.
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
FORUM RULES
Array Formula
=IFERROR(SMALL(IF(ISERROR(MATCH(ROW(INDIRECT(MIN(g):MAX(g))),g,0)),ROW(INDIRECT(MIN(g):MAX(g))),),ROW(INDIRECT(1:COUNT(IF(ISERROR(MATCH(ROW(INDIRECT(MIN(g):MAX(g))),g,0)),ROW(INDIRECT(MIN(g):MAX(g))),),)
g is your list name.
Rajan
On Thursday, 4 October 2012 19:14:56
Hi
Please refer link for details:
Link http://www.ozgrid.com/Excel/autocomplete-validation.htm
Rgds//Vabs
On Tuesday, September 25, 2012 3:24:58 PM UTC+5:30, Manoj Kumar wrote:
Hi,
Is there an way to autocomplete the words from the custom list. When
someone type the first word, the word
Not able to understand clearly. can you please the solution in the attached
file.
On Tue, Sep 25, 2012 at 5:07 PM, Vabz v...@vabs.in wrote:
Hi
Please refer link for details:
Link http://www.ozgrid.com/Excel/autocomplete-validation.htm
Rgds//Vabs
On Tuesday, September 25, 2012 3:24:58
Hi,
Attached is the solution based on link provided by Vabz. But it only work
for consecutive cells.
Other solution is use Data Validation. It will not give you auto complete
option. It will give you dropdown for cell and user have to select value
from drop down.
Regards,
Swapnil.
On Tue, Sep
Thnks for reply. The validation list need to be updated in regular basis
and also i have very long list and also can not hide too much rows in the
sheet.
Is there any VBA solution for this?
I am looking for quite a long time and but didnot manage to get it.
On Tue, Sep 25, 2012 at 5:40 PM,
-Macros$$ Re: Need Help in AutoComplete with Custom List
Hi,
Attached is the solution based on link provided by Vabz. But it only work
for consecutive cells.
Other solution is use Data Validation. It will not give you auto complete
option. It will give you dropdown for cell and user have
@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom
List
** **
Hi,
Attached is the solution based on link provided by Vabz. But it only work
for consecutive cells.
Other solution is use Data Validation. It will not give you auto
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
Hello Khan,
Please check the file attached , hope it helps.
On Tuesday, July 10, 2012 1:05:17 PM UTC+3, Imran khan wrote:
Hello,
I need IF formula in attached sheet. IF Column C0, Then Pre-Ops otherwise
Construction, IF Column F0, then Commissioning otherwise Pre-Ops IF
Column I0,
Hi Mangesh,
Try using from Insert Menu -- Object -- choose Create from file and locate
your sheet path that is available in your respective file then an Icon is
displayed so being in a sheet when you click on that Icon you will get
another sheet.
Revert if you failed to understand the above. I
Hi Ahmed,
Thanks but it is not solution to my problem.
On 6/28/12, Ahmed Honest ahmedhon...@gmail.com wrote:
Hi Mangesh,
Try using from Insert Menu -- Object -- choose Create from file and locate
your sheet path that is available in your respective file then an Icon is
displayed so
That’s not possible
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mangesh Vimay
Sent: 28 June 2012 8:49
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Need
Sent: Thursday, June 28, 2012 8:49 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another
sheet
Hi Ahmed,
Thanks but it is not solution to my problem.
On 6/28/12, Ahmed Honest ahmedhon...@gmail.com wrote:
Hi Mangesh,
Try using
Hi,
This kind of functionality is available in excel i don't know but we can
achieve this not exactle but will look like this by using paste data as
picture link.
I don't know how much it will helful to you.
Regards,
Lalit Mohan
On Wednesday, 27 June 2012 20:33:43 UTC+5:30, Mangesh wrote:
Hi Sunita,
For finding max value with name you can apply this formula, Hope this will
work for you.
=INDEX($A$1:$B$14,MATCH(MAX($B$1:$B$14),$B$1:$B$14,0),1) :
INDEX($A$1:$B$14,MATCH(MAX($B$1:$B$14),$B$1:$B$14,0),2)
regards
prince
On Monday, 25 June 2012 12:13:04 UTC+5:30, suneeta wrote:
Hello Vijay.
PFA.
On Tuesday, April 24, 2012 8:31:29 AM UTC+3, Vijay Mane wrote:
Hi Experts,
Please refer file for more information
I want to calculate top performer agent according to achieved target and
quality
If there are multiple agent with same achieved target and quality
Asa,
I tried what you said but am doing something wrong. First when I used the
exact same string as both the Set variable and the Match variable it said
it needed an object.
It did not like identical names I guess?
Then I created different object names and that would compile but I have
tried
@googlegroups.com]
On Behalf Of tangledweb
Sent: Thursday, March 22, 2012 12:20 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Need help with VBAfor Excel naming and using
column names for looping
Asa,
I tried what you said but am doing something wrong. First when I used
wksPivotSheet.Name = PivotSummary
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rekha siri
Sent: Jan/Fri/2012 10:54
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Need help in building pivot using vba
Need pivot macro
hi Ansari,
I am bit new to vba coding as this pivot source data is within sheet as per
attached sheet .
*my query is *
if i have data in different sheet please advise.
can you please help to provide this below listed steps code
1) to copy particular sheet from one existing workbook to
Need pivot macro assistance..
On Wed, Jan 18, 2012 at 9:59 PM, rekha siri rekha.siri2...@gmail.comwrote:
hi experts,
Please provide the code to build pivot using vba
this macro is provided to me in past by rajan really thank full for the
concern.
adding to that i need to prepare
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Need help with screen tip
All is there a resolution for this??
Krishnan
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From: krishnanm2...@gmail.com
Date: Sun, 6 Nov 2011 18:21:31
To: excel-macros
-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Need help with screen tip
All is there a resolution for this??
Krishnan
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From: krishnanm2...@gmail.com
Date: Sun, 6 Nov 2011 18:21:31
All is there a resolution for this??
Krishnan
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From: krishnanm2...@gmail.com
Date: Sun, 6 Nov 2011 18:21:31
To: excel-macros@googlegroups.com
Reply-To: krishnanm2...@gmail.com
Subject: Need help with screen tip
All - I need some
You can use hyperlinks with custom screen tips in small shapes placed on
top of your actual image, and make those shapes transparent.
Regards,
Sam Mathai Chacko
On Mon, Nov 7, 2011 at 9:02 AM, krishnanm2...@gmail.com wrote:
All is there a resolution for this??
Krishnan
Sent on my
Hope this will work..
On Fri, Jun 17, 2011 at 11:23 PM, airen airen1...@gmail.com wrote:
Members please Help..
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Tx Deepak
Regards
Akhilesh Airen
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
let there is a table and i want to sort the records of this table
using some attribute say pin code. the above algo sort only pin
codes.. i want to sort records using coding only..
i don't want to use range().sort
--
Members please Help..
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Your code is working fine...Can you elaborate what do you want to do,
exactly?
On Jun 16, 3:11 pm, airen airen1...@gmail.com wrote:
Sub bubblesort()
Dim i As Integer, j As Integer, n As Integer, temp As Single
n = Selection.Rows.Count
For j = n To 3 Step -1
For i = 1 To j - 1
Dear Syed,
Pls attach the solution file.
Pls let me know was it helpful or any problem.
Warm Regards
Bhushan Sabbani
+91 98208 26012
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Subject: Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs columns
=CONCATENATE(A2, ,B2, ,C2)
Dave
Mar 7, 2011 06:51:07 AM, excel-macros@googlegroups.com wrote:
data attached
On Mon, Mar 7, 2011 at 3:47 PM, Krish wrote:
Hi ,
I have data in row and column 1-3, and needs to club
...@verizon.net
*To:* excel-macros@googlegroups.com; kandy.kr...@gmail.com
*Sent:* Mon, March 7, 2011 1:32:54 PM
*Subject:* Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs
columns
=CONCATENATE(A2, ,B2, ,C2)
Dave
Mar 7, 2011 06:51:07 AM, excel-macros@googlegroups.com wrote
1 - 100 of 228 matches
Mail list logo