User Profile
IdowhatIwantsometimes
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Index and Match
it is closer to what i need. i have 48 companies. there will be a worksheet for each company. the first sheet will have all the companies and their rows in a data dump. i need to see the data for each company on each sheet. every sheet will have the company name in cell A1. your solution only shows the same company on every sheet.1.8KViews0likes2CommentsIndex and Match
Can someone help me with my issue? I only want to display companies from sheet one on sheet 2 that have a match for cell A1 on sheet 2. Current workbook formulas. Sheet 1 last column, =IF(ISNA(MATCH(C2,{"abc","abc1","abc2","abc3"},0)),"-",MAX(I$1:I1)+1) Date serial number company Review Date Status 5/1/2018 B12345 ABC 5/1/2018 Accepted 1 5/2/2018 B23456 ABC1 5/2/2018 Consider 2 5/3/2018 B34567 ABC2 5/3/2018 Compare Elsewhere 3 5/4/2018 B45678 ABC3 5/4/2018 Rejected 4 5/5/2018 C12345 ABC 5/4/2018 Accepted 5 5/5/2018 C23456 ABC1 5/2/2018 Consider 6 5/5/2018 D12345 ABC2 5/3/2018 Compare Elsewhere 7 5/5/2018 D24567 ABC3 5/4/2018 Rejected 8 Sheet 2 Each data point in all three columns =IFERROR(INDEX('Sheet 1'!A:A,MATCH(ROWS($2:2),'Sheet 1'!$I:$I,0)),"") =IFERROR(INDEX('Sheet 1'!B:B,MATCH(ROWS($2:2),'Sheet 1'!$I:$I,0)),"") =IFERROR(INDEX('Sheet 1'!C:C,MATCH(ROWS($2:2),'Sheet 1'!$I:$I,0)),"") ABC date serial number Company 5/1/2018 B12345 ABC 5/2/2018 B23456 ABC1 5/3/2018 B34567 ABC2 5/4/2018 B45678 ABC3 5/5/2018 C12345 ABC 5/5/2018 C23456 ABC1 5/5/2018 D12345 ABC2 5/5/2018 D24567 ABC3 Thank you in advance. JosieSolved1.9KViews0likes4CommentsRe: Match Cells on Sheet 1 & 2 and return value from a cell on Sheet 2 to a new cell on Sheet 1
SergeiBaklan Can you help me with my issue too? I only want to display companies from sheet one on sheet 2 that have a match for cell A1 on sheet 2. Sheet 1 last column, =IF(ISNA(MATCH(C2,{"abc","abc1","abc2","abc3"},0)),"-",MAX(I$1:I1)+1) Date serial number company Review Date Status 5/1/2018 B12345 ABC 5/1/2018 Accepted 1 5/2/2018 B23456 ABC1 5/2/2018 Consider 2 5/3/2018 B34567 ABC2 5/3/2018 Compare Elsewhere 3 5/4/2018 B45678 ABC3 5/4/2018 Rejected 4 5/5/2018 C12345 ABC 5/4/2018 Accepted 5 5/5/2018 C23456 ABC1 5/2/2018 Consider 6 5/5/2018 D12345 ABC2 5/3/2018 Compare Elsewhere 7 5/5/2018 D24567 ABC3 5/4/2018 Rejected 8 Sheet 2 Each data point in all three columns =IFERROR(INDEX('Sheet 1'!A:A,MATCH(ROWS($2:2),'Sheet 1'!$I:$I,0)),"") =IFERROR(INDEX('Sheet 1'!B:B,MATCH(ROWS($2:2),'Sheet 1'!$I:$I,0)),"") =IFERROR(INDEX('Sheet 1'!C:C,MATCH(ROWS($2:2),'Sheet 1'!$I:$I,0)),"") ABC date serial number Company 5/1/2018 B12345 ABC 5/2/2018 B23456 ABC1 5/3/2018 B34567 ABC2 5/4/2018 B45678 ABC3 5/5/2018 C12345 ABC 5/5/2018 C23456 ABC1 5/5/2018 D12345 ABC2 5/5/2018 D24567 ABC3 Thank you in advance. Josie80KViews0likes1CommentRe: Presenting a Power Bi report
Jason Drew This is Microsoft hard at work, making sure you don't get a product that will actually work. The tool's name would suggest that is powerful! It is the exact opposite! You can't export "dashboard" to anything that is shareable. The "export" is only a screenshot. You can export as a CSV BUT, and you probably know this, CSV's don't retain your formats! If you can't tell, I feel this is the DUMBEST tool Microsoft has ever released! You can create an amazing report but you are not allowed to share it!4.3KViews1like0Comments
Recent Blog Articles
No content to show