Latest Posts From Maruf Niaz
In this article, we will demonstrate some easy methods to sort data in Excel. Sometimes it’s difficult to find data of interest in a random dataset. Sorting ...
Maruf Niaz
Excel is a popular tool for doing regression analysis because it has a user-friendly interface and a variety of features. Here's the dataset we'll use to ...
Geocoding is the process of converting addresses or place names into geographic coordinates. Geographic coordinates are typically latitude and longitude. In ...
In this article, we will show you how you can clear contents in Excel easily. Working with large datasets may require you to clear the contents of datasets ...
The image below showcases the Excel tooltip on hover. Use of Excel Tooltip You can use the tooltip to: Input Data Explain Data Display a ...
In this article, we will discuss how you can use this function in VBA in Excel with different examples. The Range function is one of the most important and ...
Summing is one of the most performed operations in Excel. In Excel, there are multiple functions that you can use to sum values. Among these, the SUMIF ...
Hello HENRY,
I hope you are doing well and thank you for your query. You can use the following formula to see which group these names are from.
=INDEX($B$4:$D$4,MOD(ROW(B5)-5,COLUMNS($B$4:$D$4))+1)
The formula uses INDEX, MOD, ROW and COLUMNS functions to look up the values in cells within column F and returns the corresponding group names in column G.
Here is an image displaying the result in an Excel sheet:
Regards
Maruf Niaz || ExcelDemy