Tag: Excel Class

Uncategorized Leave a comment

Concatenate Multiple values in one cell

                    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 more
EXCEL VBA TIPS One comment

Open Last Modified Excel File From A Folder Through Vba

Dear 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 more
LOOKUP & Reference Leave a comment

Index Function In Excel-2

Index     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
LOOKUP & Reference One comment

Index Function In Excel-1

INDEX   This function picks a value from a range of data by looking down a specified number of rows and then across a specified number of columns.   यह फंक्शन एक डाटा के दिए गए range से नीचे की ओर से number of rows और फिर दिए गए columns से डाटा उठाता है.   Syntax There are various forms of syntax for this function. इस फंक्शन के लिए अनेक प्रकार का syntax है.   Syntax 1 =INDEX(RangeToLookIn, Coordinate)   […]

Read more