MIS-Interview Series-Q7
MIS-Interview Series-Q5 Question was asked in MIS Interview. https://youtu.be/CiEq4Oi4HsI
Read moreMIS-Interview Series-Q5 Question was asked in MIS Interview. https://youtu.be/CiEq4Oi4HsI
Read moreMIS-Interview Series-Q6 Question was asked in MIS Interview. https://youtu.be/jOYpdKY-GbY
Read moreMIS-Interview Series-Q4 Question was asked in MIS Interview. https://youtu.be/JSYopkuDKA8
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 moreCopy All Sheet Data In Master_Sheet I have excel file which has 3 sheet,From below vba macro code we can copy all sheets data in master Sheet. मेरे पास तीन sheet वाली excel फाइल है.निचे लिखे VBA Macro Code से हम सारे sheets का डाटा Master Sheet में copy कर सकते हैं. Sub Add_All_sheet_Data() sheetcount = Sheets.Count Worksheets.Add after:=Sheets(Sheets.Count) ‘Worksheets.Add after:=Sheets(Sheetcount) ActiveSheet.Name = “Master” For i = 1 To sheetcount Sheets(i).Activate Range(“a1”).CurrentRegion.Select Selection.Copy Sheets(“Master”).Activate Range(“a1048576”).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste If […]
Read moreI have to extract first name from a cell in excel. हमें एक्सेल में एक cell से first नाम निकलना है. Here we have only one logic that from start to end, what is the position of first space in cell, we have deduct 1 in that position, then from left side we will pick number character with help of left function to extract first name. यहाँ हमें […]
Read more