Thread: search in Matrix and give a Alphanumber in the right row back (index,match and/or aggregat)
View Single Post
 
Old 09-13-2025, 02:05 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Have a look at the formula in cells F2 and below of the sheet Tabelle2 of the attached workbook. It should appear correctly in your German version. According to the compatibility info it should be OK with Excel 2021.
Edit: Also look at cell G2 and below which uses C2 as you asked for,
2025-09-13_220207.jpg
Attached Files
File Type: xlsx MSOfficeForums53754Silikon.xlsx (25.2 KB, 1 views)
Reply With Quote