![]() The formula is looking in a sheet called 'rawdata and checks' (the exclamation point is a useful clue to look for). ![]() This one is quite a mouthful - but you don’t have to understand it to spot the name of a sheet which is not visible: The box will probably contain a formula that provides a clue to the location of the missing data. When selected, look in the formula bar above the sheet (but below any menus) - highlighted with the red box in the image above. The first step is to click on one of the cells containing the numbers you want - the numbers that change when a different option is selected from the drop-down menu. ![]() Select a cell with data and the formula bar will show a complex formula ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |