Search results

Hi Team, Below is the code I am using with "FOR loop to concatenate the value in each row of column 2 ,3,4,5.which is taking long time as I have more than 25000 rows. while I have searched in google WITH Statement is something that I am thinking to sue to get the task done more quick. For...

I have tried as below =SUMIFS(BD185:INDEX($185:$185,MATCH("ZZZZ",$185:$185)),BD$11:INDEX($11:$11,MATCH("ZZZZ",$11:$11)),"Not Billed",BD$15:INDEX($15:$15,MATCH("ZZZZ",$15:$15)),"DTE Net Activity") resulting value error

Hello Team, Can some tell how the same works for SUMIFS? to find last columns

Hello Team, Thanks a lot on formula , got to know loft of new ting on sumifs . Appreciate it :)

Hi , I am using sumif formula (=SUMIF($BD$15:$GW$15,$AV$15,$BD17:$GW17) , however in the current formula last column is GW , but when there is increase in range from GW to NI ,i need teh formula to get the rage updated to (=SUMIF($BD$15:$NI$15,$AV$15,$BD17:$NI17). Appreciate your help in...

Thank you very much Asheesh above explanation is so perfect to make understand the formula. once again thanks a lot .

Hi , I need VBA code to Check each staring in Sheet1 from range A3 in sheets2 range A4 and identify ignores Spaces & Character "-" and place a number like 1 in Sheet2 against the identifier and also in sheet 1. I need the farmula in the Sheet2 Cell B4 to be performing VBA for each string in...

Or It would be more help full if you can explain me the formula

Hi Team, In the attachment i have been provided with a formula which ignores Special character ( Spaces & "-" to get the result in Sheets2 from Sheet 1. i need a VBA code to Identify Sheet1Range A4 value if found in Sheet 2 whole range A4 to A6 match then Place number in next coulmn cell...

Excellent Asheesh , Can we Get the Same in VBA also .as value in Sheet1 Range A4 is String which will have to Search in the range of Sheets2 Range A4 to A6 .

I need a lookup Function to do get the result

Hi Team, I need a formula which match the nearest in lookup value & lookup array ignoring the Spaces, Special character like "-". I upload sample file for your reference where is need Sheet 2 data in sheet 1 which are same but difference are Space & character. I can't remove the Space's or...

Hi Hui, I have uploaded exact replica of the action( not code ) All i need is to call very basic sample , in this all i want is to call the Userform & auto enable the Click button on the userform in Macro 1 in module 2.

Hi Team, Hope you all are doing great ... I have a cammand button to be Intiated i worksheet name "Cost" , which will show userform1 and abutton in userform to click. I want a vba code to auto click the command in worksheet and let it populate the userform and also click on the button on user...

Hi Team, Need help in Sum the value with multiple criteria across columns. Attached is the sample file. Looking forward for response.

Hi Team, Need a formula to get all the cell values which are not equal to zero in an range of cells. A B C D E Required Result Row1 0 1 0 1 1 Need Value as B,D,E Row2 0 0 1 0 1 Need Value as C,E Row3 1 0 0 1 0 Need Value as A,D Row4 0 1 1 0 1 Need Value as B,C,E

Great one thank a lot Hui:)

Hi Team, I was trying to use sumifs Formula to sum the values in the table which match the row & column. below is teh example. I need put a formula to summ all the values which are under header ZZ and matching A1 in X header.Please help urgent X XY YZ ZZ XY YZ ZZ XY YZ ZZ A1 53 66 65 29 3...

http://chandoo.org/wp/2010/08/31/dynamic-chart-with-check-boxes/ this is the link

Hi team, I was going through the Dynamic chart section in chandoo.org tutorial page and came accros this link this chart named "What our mouth-watering chart will look like when its done:" All i want to know is what exactly has to be done if we have to see the Sale has different colour and...

Hi there, i have text 8,222,90 which ideally should be 8,222.90. Inorder to do that i have used substitue formula but the same is taking the count from LEFT Instead of right. Please help.:)

Hi Team, Would you be able to provide me an sample code to export the data from an excel file to an already existing table in access database. Thanks Raghava Sharma

Thanks Luke, but this isn't working ... as my file when it is first time opened for some update's it is in TEXT(TAB DELIMITED)(*TXT) format & File is in "ABC.XLS". So when i am saving after update i need to do save as and select the format as (*XLS) and replace the file which is already...

HI team, I have written an macro where the code serve's to open file from folder saved on desktop and editing the same and i want to save as the same file in the same folder . but while doing the same excel is asking if i want to replace the existing file with the file changed in same...

Hi .. I need a macro to browse and select a folder and open all files and in each excel file it should add new sheet to it and close and save in the same folder. Thanks in advance for your help.