I have two tabs in Excel. Tab 1 is a Data tab with five columns, A thru E. The 5th column E has a Staff Name drop-down for each cell. Co... INDEX(:$D$9,MATCHData!$E2$A$,0),MATCH(A$1,'Dropdown staff %'!$B$1:$D$1,0))*$D2 Maybe with this formula which seems to ...
"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjUuMXwyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:excel","text":"exce...
I have a spreadsheet with multiple tabs, our team fill in a quantity tab on each row if they need an item. I would like to try and create a pick list of sorts on a tab so that only rows with a number in the quantity column appear in the pick list tab....
Hello, I am organising a school timetable on excel. Days of the week are on tabs. With classes on columns. Lessons in rows. Each cell has data entered like this 1A/Eng/CMC (class code/Subject... TMcIlroyMerely to demonstrate what's possible with Power Query (PQ), even ...
Hi, apologies if this has been asked before but I don't seem to find the answer and if it is possible at all. I have a spreadsheet with multiple tabs...
Hi, Can I please get some direction? I have two tabs in Excel. Tab 1 is a Data tab with five columns, A thru E. The 5th column E has a Staff Name drop-down for each cell. Co... DLobo In A2 on the Data sheet: =D2*VLOOKUP(E2,'Dropdown staff %'!$A$2:$D$1000,2,FALSE...
Hi, Can I please get some direction? I have two tabs in Excel. Tab 1 is a Data tab with five columns, A thru E. The 5th column E has a Staff Name drop-down for each cell. Co... DLobo In A2 on the Data sheet: =D2*VLOOKUP(E2,'Dropdown staff %'!$A$2:$D$1000,2,FALSE...
I have two tabs in Excel. Tab 1 is a Data tab with five columns, A thru E. The 5th column E has a Staff Name drop-down for each cell. Column D, I enter data manually. I have to input the formulas manually on columns A, B, and C. ...
I've recently helped someone with a similar issue that has already applied an array formula to pull relevant information into separate tabs in real-time. (Link) Can you attach your workbook to get a better idea of the data? Hi, Sorry I'm not sure if I really understa...
Pulling data from one tab to another Hello, I was working on a spreadsheet that is uploaded to SharePoint. I download the file so it's opened in the excel app instead of trying to update it from the web.. I was pulling data from...Show More data excel sharepoint tabs Like 0...