We have to Concatenate multiple cells value in one cell. हमें कई सारे cells का value एक cell Concatenate में करना है. There is some value in cell A1 to A6, we have to concatenate these value A1 to A6 into cell C3 with space यहाँ cell A1 से C6 में कुछ value है,हमें इन सारे values को C3 में space के साथ Concatenate करना है. Type =A1:A6&” […]
Read moreDear All, We can use below vba code to open last modified excel file from a folder. Sub Last_Modified_File() x = InputBox(“put Folder Path”) folder_name = x & “\” flname = Dir(folder_name & “*.xlsx”) Do While Len(flname) > 0 dttime = FileDateTime(folder_name & flname) If dttime > qq Then qq = dttime End If flname = Dir() Loop folder_name = x & “\” flname = Dir(folder_name & “*.xlsx”) Do While Len(flname) > 0 dttime = FileDateTime(folder_name & flname) […]
Read moreUse of Match Function With Index Match Function के साथ Index फंक्शन का प्रयोग The INDEX MATCH formula is the combination of two functions in Excel: INDEX and MATCH. INDEX MATCH formula Excel में Index और Match दो Functions का संयोजन है। =INDEX() returns the value of a cell in a table based on the column and row number. Column और Row की संख्या के आधार पर तालिका में cell का Value लौटाता है। =MATCH() returns the […]
Read moreMKDIR In excel vba we use MKDIR vba function to create folder. MKDIR Function का उपयोग हम excel vba में folder बनाने के लिए करते है. I have to make a folder in D Drive which name will be computer. For this we have type code हमें D drive में एक फोल्डर बनाना है जिसका नाम COMPUTER होगा. इसके लिए हमें यह कोड लिखना होगा. Sub MakeFolder() MkDir “D:\COMPUTER” End Sub This Code will make folder in D Drive. यह […]
Read moreMATCH Function in Excel एक्सेल में मैच फंक्शन का प्रयोग With the help of match function we find out position of a lookup value in a row or column. It does not return the value. MATCH supports approximate and exact matching, and wildcards (* ?) for partial matches. We often use match with Index and Vlookup for getting data. It can be used with text and numbers. This function looks for an item in a list and shows its position. […]
Read moreIndex With the help of INDEX function in excel we get value from a table or range on the intersection of a row and column position within the table or range. The first row in the table is row 1 and the first column in the table is column 1. एक्सेल मं हम Index फंक्शन की मदद से table या range से हम row और columne के कटाव का value प्राप्त करते हैं. पहला row table में […]
Read more