Re: $$Excel-Macros$$ VLOOKUP_HELP

Thankyou so much Friends. Simply your great people. Thanks N.Sundarvelan 9600160150 On Thu, Mar 28, 2013 at 11:32 AM, NOORAIN ANSARI wrote: > Dear Sundar, > > > Please see attachment , Hope it will help to you. > > > On Thu, Mar 28, 2013 at 11:18 AM, Sundarvelan N wrote: > >> Dear Friends, >>

Re: $$Excel-Macros$$ Re: Sumproduct Formula -Min-Function-Error

Dear Praful, If u evaluate the formula. On Thu, Mar 28, 2013 at 11:43 AM, prafull jadhav wrote: > Dear Anil, > > My Question is why not from Sumproduct ... > > I dont want to use arry formula,=SUMPRODUCT(MIN(($E$6:$E$20=** > E6)*($F$6:$F$20))) > > Then from Min(($E$6:$E$20=**E6) it shows false,

$$Excel-Macros$$ please help to read the figures in words

Dear Friends Will any body help me to read the figures in words I want the read the figures given "UNDER RATE IN FIG" - RESULT IN " FIGURES IN WORDS" Thanks in advance -- GRKNAIDU -- 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 off

Re: $$Excel-Macros$$ Re: Sumproduct Formula -Min-Function-Error

Dear Anil, My Question is why not from Sumproduct ... I dont want to use arry formula, Regardas, Prafull. On Thu, Mar 28, 2013 at 11:34 AM, अनिल नारायण गवली wrote: > Dear Praful, > > It will come with min and if condition. > > > See the attached sheet. > > Warm Regards, > Gawli Anil > > On Th

Re: $$Excel-Macros$$ Re: Sumproduct Formula -Min-Function-Error

Dear Praful, It will come with min and if condition. See the attached sheet. Warm Regards, Gawli Anil On Thu, Mar 28, 2013 at 11:18 AM, prafull jadhav wrote: > Dear Prince, > > find the same. > > Regards, > Prafull Jadhav. > > > On Thu, Mar 28, 2013 at 9:19 AM, Prince wrote: > >> Share your

Re: $$Excel-Macros$$ Re: Sumproduct Formula -Min-Function-Error

Dear Prince, find the same. Regards, Prafull Jadhav. On Thu, Mar 28, 2013 at 9:19 AM, Prince wrote: > Share your workbook. > > Regards > Prince > > On Wednesday, March 27, 2013 6:05:37 PM UTC+5:30, prafull jadhav wrote: >> >> Dear All, >> >> Sumproduct function return the Max function output b

Re: $$Excel-Macros$$ IGNORE_BLANK_CELLS_AND_COMBINE_WITH_UNIQUE

Dear Sundarvelan , first select the coloum of A then press cltr+f in find place put 9 then click on find All button. . Then it will show u how many records found then select all the reference sheets . By selecting all the reference sheets it will select all the cells then click on close button. co

Re: $$Excel-Macros$$ IGNORE_BLANK_CELLS_AND_COMBINE_WITH_UNIQUE

hi, if you are using MS office 2007 above.. >> select the column from where you want to remove the blanks >> go to DATA tab >> Select remove duplicates >> you will left with only one blank >> that you can remove manually.rest the thing will be as desired by you regards Viney Mehta

$$Excel-Macros$$ Re: Wish you all a very happy holi

happy holi to all On Wednesday, March 27, 2013 9:30:38 AM UTC+5:30, ashish wrote: > > > > > > *Regards* > *Ashish Koul* > *Excel VBA > Tips

$$Excel-Macros$$ IGNORE_BLANK_CELLS_AND_COMBINE_WITH_UNIQUE

Dear Freinds, Please help me to combine ignoring the blank cells Thanks N.Sundarvelan 9600160150 -- 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

$$Excel-Macros$$ Re: use cell address in offset

PLEASE SHARE YOUR WORKBOOK On Wednesday, March 27, 2013 2:03:30 PM UTC+5:30, Sundarvelan wrote: > > > Dear Friends, > > Please help me in using the cell address in offset. > > > =IF((IF('TNCMCHIS_CALC-2'!$R8=1,'TNCMCHIS_CALC-2'!$A8,OFFSET('TNCMCHIS_CALC-2'!$R8,0,-17,1,1)))=$A6,OFFSET( > 'TNC

$$Excel-Macros$$ Re: Sumproduct Formula -Min-Function-Error

Share your workbook. Regards Prince On Wednesday, March 27, 2013 6:05:37 PM UTC+5:30, prafull jadhav wrote: > > Dear All, > > Sumproduct function return the Max function output but Not a Min fuction > Output . > > for example > > I got output when i use max function but when i try to get output

Re: $$Excel-Macros$$ Financial year Graph

Dear Experts, Sorry for the late reply. Thank you all for the help. Can we make in the pivot table iteslf the same financial year as we did ? Regards, Chaya On Wed, Mar 27, 2013 at 6:35 PM, Amit Desai (MERU) wrote: > FYI, > > ** ** > > Please find attached altered file. > > ** *

$$Excel-Macros$$ Re: Alternative formula

Hi Hilary, Can we do it through VBA as i tried to make this formula work fast but did not get success. So i think VBA would be the best option in case. regards prince On Wednesday, March 27, 2013 7:11:56 PM UTC+5:30, hilary lomotey wrote: > > Hello Experts, > > i am working with a lot of data a

$$Excel-Macros$$ Re: Index / Match formula - Ignoring blank cells

please share your workbook or provide us some sample data. for ur reference please see the attached. On Wednesday, March 27, 2013 8:42:01 PM UTC+5:30, srsev6 wrote: > > I have the following formula that would be working perfectly if it ignored > blank cells. > > The formula I am using is:

$$Excel-Macros$$ Re: Need help using Modules in Excel 2007

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: >> >

Re: $$Excel-Macros$$ Previous sheet name using formula

Thanks Paul and My Dear Friends. My question was to get sheet name which is left of my current sheet by formula. Any how i found solution completed my project by other way. Thanks N.Sundarvelan 9600160150 On Wed, Mar 27, 2013 at 9:49 PM, Sam Mathai Chacko wrote: > You could also use the MI

$$Excel-Macros$$ Re: Need help using Modules in Excel 2007

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, th

Re: $$Excel-Macros$$ Sample Data

It is definitely NOT that. On Wednesday, March 27, 2013 4:14:26 PM UTC-4, Aikistan wrote: > That worked! However...now they want to generate links to the 50+ sheets, > rather than the values themselves. Would that be: > > rng2.Copy Destination.Formula:= "=" & rng.Address(0, 0) > > Thanks!

Re: $$Excel-Macros$$ Sample Data

That worked! However...now they want to generate links to the 50+ sheets, rather than the values themselves. Would that be: rng2.Copy Destination.Formula:= "=" & rng.Address(0, 0) Thanks! On Wednesday, March 27, 2013 12:37:56 PM UTC-4, ashish wrote: > Please try the attached file > > 1 Cli

$$Excel-Macros$$ Regarding cariier in SQL SSRS SSIS and SAP ABAP

Hi Anybody who want to explore carrier in MS-BI objects,SQL or SAP/ABAP,VBA then feel free to contact on 9953256629/9910893918 I am not a trainer just like as an employees who is working in the same domain knowledge currently I am working in United Health Group As an Sr. Software Developer -- sy

Re: $$Excel-Macros$$ Sample Data

Please try the attached file 1 Click on get file names to import the full path of all files to be merged in the worksheet 2 click on merge to merge the data and paste it in output sheet. Currently u need to change date in code . you can use input-box or date picker option if u want to select date

Re: $$Excel-Macros$$ Previous sheet name using formula

You could also use the MID function instead of REPLACE example =MID(CELL("filename"),FIND("]",CELL("filename"))+1,31) Note that the second formula in my previous post requires enabling your macro settings. So I am not sure how much that is helpful in the end (assuming the reason you wanted to do

Re: $$Excel-Macros$$ Previous sheet name using formula

I would agree with Paul. The best thing to do is to write a function like this Function PREVSHEETNAME() As String On Error Resume Next PREVSHEETNAME = ActiveSheet.Previous.Name Application.Volatile End Function On the contrary, if you are still intent on doing this with formula, you

Re: $$Excel-Macros$$ Need help using Modules in Excel 2007

First of all, .xlsx files are designed SPECIFICALLY to remove all modules when the file is saved. (Microsoft hoped to use this as a mechanism to reduce the spread of viruses) Second, when you save the file, close and reopen it, (assuming .xlsm or .xlsb format) is the macro module still there? I

$$Excel-Macros$$ Sample Data

Sorry, didn't see your post until after my cut/paste. Here are 2. -- Stan -- 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

$$Excel-Macros$$ Need help using Modules in Excel 2007

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 formula's don't seem to work -- I get 'NAME' error in cell with formula indicating unre

Re: $$Excel-Macros$$ Macro newb - copy rows from multiple workbooks using condition

email ur file on this id *excel-macros@googlegroups.com * On Wed, Mar 27, 2013 at 8:58 PM, Aikistan wrote: > Um...no, it won't let me attach my files here. I think my browser's > unsupported. (Client's computer...I can't change anything.) > > > On Wednesday, March 27, 2013 11:08:26 AM UTC-4,

Re: $$Excel-Macros$$ Macro newb - copy rows from multiple workbooks using condition

Um...no, it won't let me attach my files here. I think my browser's unsupported. (Client's computer...I can't change anything.) On Wednesday, March 27, 2013 11:08:26 AM UTC-4, ashish wrote: > Can u share some sample input workbooks > Sent on my BlackBerry® from Vodafone > ---

$$Excel-Macros$$ Index / Match formula - Ignoring blank cells

I have the following formula that would be working perfectly if it ignored blank cells. The formula I am using is: =INDEX(Sheet1!$F$2:$F$2250,MATCH(1,IF(Sheet1!$C$2:$C$2250=C4,IF(Sheet1!$D$2:$D$2250=$D$1,0 Unfortunately, if the cell with the result is blank it returns a 1/0/1900. I wo

Re: $$Excel-Macros$$ Macro newb - copy rows from multiple workbooks using condition

Can u share some sample input workbooks Sent on my BlackBerry® from Vodafone -Original Message- From: Aikistan Sender: excel-macros@googlegroups.com Date: Wed, 27 Mar 2013 08:06:39 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro newb - copy rows from multipl

$$Excel-Macros$$ Macro newb - copy rows from multiple workbooks using condition

Hello everyone, this is my first post here, so please bear with me. I have about 50 individual workbooks with the same layout and I need to combine them into another workbook but only if cells in column D meet my criteria. The columns are A-D and contain ID, Name, Amount, and Date. I need on

$$Excel-Macros$$ Alternative formula

Hello Experts, i am working with a lot of data and am using this formula +IFERROR(INDEX(Sheet1!$B$1:$B$10061,SMALL(IF(Sheet1!$B$1:$B$10061=Sheet1!$H$1,ROW(Sheet1!$B$1:$B$10061)-ROW(Sheet1!$B$1)+1,""),ROW(A1))),"") to retrieve items in list b1:b1 that corresponds to item in h1 . i have however

Re: $$Excel-Macros$$ Previous sheet name using formula

How do you define "Previous Sheet Name"? Do you mean the name of the sheet before it was changed to the current name? or do you mean the name of the sheet immediately to the left of the selected sheet? Also, you said "using formula", does that mean you wish for an excel function that will show (

$$Excel-Macros$$ Previous sheet name using formula

Dear Friends, Please help me to get the previous sheet name using formula Thanks N.Sundarvelan 9600160150 -- 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

$$Excel-Macros$$ Sumproduct Formula -Min-Function-Error

Dear All, Sumproduct function return the Max function output but Not a Min fuction Output . for example I got output when i use max function but when i try to get output for min value out put is Zero. =SUMPRODUCT(MAX(($E$6:$E$20=E6)*($F$6:$F$20))) E column is Region and F column is Amount R

$$Excel-Macros$$ use cell address in offset

Dear Friends, Please help me in using the cell address in offset. =IF((IF('TNCMCHIS_CALC-2'!$R8=1,'TNCMCHIS_CALC-2'!$A8,OFFSET('TNCMCHIS_CALC-2'!$R8,0,-17,1,1)))=$A6,OFFSET( 'TNCMCHIS_CALC-2'!$A6,('TNCMCHIS_CALC-2'!$R6),0,1,1),"CONTINUE") I want to use the below output in the above highlighted