{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Quick View","1. Basic Example","2. Dynamic Arrays","3. Highlighting ","4. Groups of Rows","5. INDIRECT","6. INDEX MATCH","7. HLOOKUP","8.VBA ROW"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Quick View","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"ROW Function Excel"]
[]
[null,"Returns the row number of a reference"]
[null,"=ROW (reference)"]
[]
[null,"Input 1","Row Number","Formula","Explanation"]
[null,null,{"$f":"ROW()","v":7},{"$f":"_xlfn.FORMULATEXT(C7)","v":"=ROW()"},"Returns the row number for empty cell"]
[null,50,{"$f":"ROW()","v":8},{"$f":"_xlfn.FORMULATEXT(C8)","v":"=ROW()"},"Returns the row number for a single cell"]
[null,46,{"$f":"ROW()","v":9},"=ROW()","Returns the row number for a single cell"]
[null,"$B$6",{"$f":"ROW()","v":10},"=ROW()","Returns the row nuber for absolute cell reference"]
[null,"4:4 (Row 4)",{"$f":"ROW(4:4)","v":4},{"$f":"_xlfn.FORMULATEXT(C11)","v":"=ROW(4:4)"},"Returns the row number for the 4th row"]
[null,"D:D (Column D)",{"$f":"ROW(D:D)","v":1},"{=ROW(D:D)}","Returns the row number for column D"]
[null,"B6:B7",{"$f":"ROW(B6:B7)","v":6},"{=ROW(B6:B7)}","Returns the row number for a range of cell"]

{"sheet":"1. Basic Example","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,4],[4,1,4,4],[6,1,6,4],[9,1,9,4]]}
[]
[null,"Basic Examples of Using ROW Function"]
[]
[null,"Item","Price","Row Number","Formula"]
[null,"When No Reference Is Used"]
[null,"Refrigeretor",500,{"$f":"ROW()","v":6},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=ROW()"}]
[null,"When a Single Cell Is Used as Reference"]
[null,"TV",300,{"$f":"ROW(B8)","v":8},{"$f":"_xlfn.FORMULATEXT(D8)","v":"=ROW(B8)"}]
[null,"Desktop",400,{"$f":"ROW(B9)","v":9},{"$f":"_xlfn.FORMULATEXT(D9)","v":"=ROW(B9)"}]
[null,"When an Absolute Cell Reference Is Used"]
[null,"Mop",10,{"$f":"ROW($B$6)","v":6},{"$f":"_xlfn.FORMULATEXT(D11)","v":"=ROW($B$6)"}]
[null,"When Range of Cells Is Used as Reference"]
[null,"Oven",200,{"$f":"ROW(B13:C13)","v":13},{"$f":"_xlfn.FORMULATEXT(D13)","v":"=ROW(B13:C13)"}]

{"sheet":"2. Dynamic Arrays","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dynamic Arrays Using ROW Function"]
[]
[null,"Product","Row Number"]
[null,"TV",{"$f":"ROW(B5:B14)","v":5}]
[null,"Desktop",6]
[null,"Monitor",7]
[null,"Hard Disk",8]
[null,"AC",9]
[null,"Keyboard",10]
[null,"TV",11]
[null,"Fan",12]
[null,"Desktop",13]
[null,"Monitor",14]

{"sheet":"3. Highlighting ","index":3,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Highlighting Alternate Rows Using ROW Function"]
[]
[null,"Product","Price","Manufacturer"]
[null,"TV",500,"Silo Digital"]
[null,"Desktop",300,"Dell"]
[null,"Monitor",260,"Acer"]
[null,"Hard Disk",100,"IBM"]
[null,"AC",550,"Silo Digital"]
[null,"Keyboard",30,"IBM"]
[null,"TV",450,"Panasonic"]
[null,"Fan",100,"DLB"]
[null,"Desktop",270,"IBM"]
[null,"Monitor",200,"Acer"]
[null,"Hard Disk",100,"IBM"]
[null,"AC",550,"Singer"]
[null,"Keyboard",30,"IBM"]
[null,"TV",450,"Panasonic"]

{"sheet":"4. Groups of Rows","index":4,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Showing Groups of Rows"]
[]
[null,"Product","Price","Manufacturer"]
[null,"TV",500,"Silo Digital"]
[null,"Desktop",300,"Dell"]
[null,"Monitor",260,"Acer"]
[null,"Hard Disk",100,"IBM"]
[null,"AC",550,"Silo Digital"]
[null,"Keyboard",30,"IBM"]
[null,"TV",450,"Panasonic"]
[null,"Fan",100,"DLB"]
[null,"Desktop",270,"IBM"]
[null,"Monitor",200,"Acer"]
[null,"Hard Disk",100,"IBM"]
[null,"AC",550,"Singer"]
[null,"Keyboard",30,"IBM"]
[null,"TV",450,"Panasonic"]
[null,"Hard Disk",100,"IBM"]
[null,"AC",550,"Singer"]

{"sheet":"5. INDIRECT","index":5,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combining ROW with INDIRECT Function"]
[null,null,null,null,"Row Number"]
[null,"Product","Price","Manufacturer",{"$f":"ROW(INDIRECT(\"1:\"&COUNTA(D:D)))","v":1}]
[null,"TV",500,"Silo Digital",2]
[null,"Desktop",300,"Dell",3]
[null,"Monitor",260,"Acer",4]
[null,"Hard Disk",100,"IBM",5]
[null,"AC",550,"Silo Digital",6]
[null,"Keyboard",30,"IBM",7]
[null,"TV",450,"Panasonic",8]
[null,"Fan",100,"DLB",9]
[null,"Desktop",270,"IBM",10]
[null,"Monitor",200,"Acer",11]
[null,"Hard Disk",100,"IBM",12]
[null,"AC",550,"Singer",13]
[null,"Keyboard",30,"IBM",14]
[null,"TV",450,"Panasonic",15]

{"sheet":"6. INDEX MATCH","index":6,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Use of ROW with INDEX MATCH Formula"]
[]
[null,"Product","Manufacturer","Price"]
[null,"TV","Silo Digital",500]
[null,"Desktop","Dell",300]
[null,"Keyboard","Acer",30]
[null,"Hard Disk","IBM",100]
[null,"AC","Silo Digital",550]
[null,"Monitor","IBM",260,null,"Product","Row Number"]
[null,"TV","Panasonic",450,null,"Keyboard",{"$f":"ROW(INDEX(B4:D18,MATCH(F11,B4:B18,0),2))","v":7}]
[null,"Fan","DLB",100]
[null,"Desktop","IBM",270]
[null,"Monitor","Acer",200]
[null,"Hard Disk","IBM",100]
[null,"AC","Singer",550]
[null,"Fan","IBM",30]
[null,"TV","Panasonic",450]

{"sheet":"7. HLOOKUP","index":7,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Combining ROW & HLOOKUP Functions"]
[null,"Row Number"]
[null,{"$f":"ROW(C4:C18)-3","v":1},"Product","Manufacturer","Price"]
[null,{"$f":"ROW(C5:C19)-3","v":2},"TV","Silo Digital",500]
[null,{"$f":"ROW(C6:C20)-3","v":3},"Desktop","Dell",300]
[null,{"$f":"ROW(C7:C21)-3","v":4},"Monitor","Acer",260]
[null,{"$f":"ROW(C8:C22)-3","v":5},"Hard Disk","IBM",100,null,"Product","Price"]
[null,{"$f":"ROW(C9:C23)-3","v":6},"AC","Silo Digital",550,null,"TV",{"$f":"HLOOKUP(H8,C4:E18,ROW(E8),0)","v":450}]
[null,{"$f":"ROW(C10:C24)-3","v":7},"Keyboard","IBM",30]
[null,{"$f":"ROW(C11:C25)-3","v":8},"TV","Panasonic",450]
[null,{"$f":"ROW(C12:C26)-3","v":9},"Fan","DLB",100]
[null,{"$f":"ROW(C13:C27)-3","v":10},"Desktop","IBM",270]
[null,{"$f":"ROW(C14:C28)-3","v":11},"Monitor","Acer",200]
[null,{"$f":"ROW(C15:C29)-3","v":12},"Hard Disk","IBM",100]
[null,{"$f":"ROW(C16:C30)-3","v":13},"AC","Singer",550]
[null,{"$f":"ROW(C17:C31)-3","v":14},"Keyboard","IBM",30]
[null,{"$f":"ROW(C18:C32)-3","v":15},"TV","Panasonic",450]

{"sheet":"8.VBA ROW","index":8,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[15,3,15,6],[17,3,17,6]]}
[]
[null,"Row Number Using VBA "]
[]
[null,"Input","Price","Row Number"]
[null,"Mop",10]
[null,"TV",300]
[null,"Desktop",400]
[null,"TV",450]