You have come to the right place if you are looking for the answer or some unique tips to translate an Excel file to English. There are some easy ways of how ...

For research purposes, most of the time you may need to do an Iterative calculation. Sometimes, you may face the problem that you need to iterate but Excel is ...

Copy-Paste is a very useful feature in Excel. Sometimes, you may face the problem that you need to copy the formulas along with the values or even only ...

Suppose you have to deal with lots of data. In that case, you may need to copy Data Validation in Excel. In this article, I will explain how to copy Data ...

Sometimes you may need to convert XML to an Excel table. In this article, I will explain how to convert XML to an Excel table using Microsoft 365 version. ...

Sometimes for stock visualization, you may need to prepare a Stock comparison chart in Excel. Furthermore, you can easily visualize the situation with data ...

Sometimes for data visualization, you may need to make a chart. If you are looking for how to use multiple colors in the background of a chart in Excel, then ...

Sometimes you may need to calculate Return on Investment (ROI) percentage in Excel. In this article, I will explain how to calculate ROI percentage in Excel ...

Sometimes you may need to print out your data or Excel spreadsheets. In that case, if there are Borders then it will be easy to read the data. But sometimes ...

If you are searching for a solution or some special tricks to prepare a Rental property balance sheet in Excel, then you have landed in the right place. ...

Sometimes you may need to do randomized block design ANOVA in Excel for any research purpose. In addition, you can find out lots of statistical terms like ...

Occasionally you may need to Add or Subtract based on cell value in Excel. So, if you are looking for how to Add or Subtract based on cell value in Excel then ...

Sometimes you may need to use the AVERAGEIF function with multiple criteria in Excel. So, if you are looking for the use of an AVERAGEIF function with multiple ...

If you are looking for how to do the Subtotal Average in Excel, then you have come to the right place. In this article, I will explain how to do the Subtotal ...

When you need to convert any negative values into positive ones then you may use the ABS function in Excel. But, I will explain today how to use the opposite ...

- « Previous Page
- 1
- 2
- 3
- 4
- 5
- …
- 7
- Next Page »

Thank you, CARLOS for your comment. You have to use the correct array (

Sales Repor

B5:B14) inINDEXfunction andRankColumn (D5:D14) inMATCHfunction. Also, while using theFill Handleicon, you have to freeze both arrays. The most important part, you must write Rank1,2,3..manually inGeneralformat inF column.There may have

extra spaceorApostrophe(‘) in theF columnwhere you insert Rank numbers manually. You should remove all extra spaces.You can see our article related

MATCHfunction error. The link is:https://www.exceldemy.com/excel-match-function-not-working/#Case_1_NA_ErrorFor getting basic idea of

INDEX-MATCHfunction you can see the examples from this articlehttps://www.exceldemy.com/excel-index-match-example/Still, you are facing the problem then please comment with your used formula and sample dataset.

Regards

Musiha Mahfuza Mukta| Team Exceldemy.

Thanks, KYLE, for your query. If there are identical values, then it will give same Rank. Also, the

RANKfunction will skip one Rank. For your better understanding, I’m changing the sales value ofJaniferto$9158. So,ZuschussandJaniferget the same rank (2nd). Thus, the3rdrank will be missed. Here, you must re-write the Rank ofF7cell to “2” and change the array forINDEX-MATCHfunction using inG7anH7cell. Basically, you need to set the array withoutZuschussinformation. Below, I have attached the whole scenario.There is another way, if you want to get

unique Rankfor all. LikeZuschusscomes first thanJanifersoZuschusswill get2ndrank andJaniferwill get3rdrank. In this case, you just need to change the formula inD columngiven below:=RANK(C5,$C$5:$C$14,0)+COUNTIF($C$5:C5,C5)-1You don’t need to change the array of

INDEX-MATCHfunction.Regards

Musiha Mahfuza Mukta| Team Exceldemy

Hi ATIF, Thanks for your comment. Here, I made a dataset keeping the

Textvalue inA column,Datevalue inB columnandCounterwill be inC column. If you provide your Excel file, then it will be more useful. As per my understanding, I am providing the following VBA code.From Developer tab >> go to Visual Basic >> Insert a Module >> copy the code in that >> from Macros >> Run the code.

You can see the outcome below.

Where the counter counts single value for same date. I have highlighted the same date. Also, for “Abnormal” text the counter didn’t count.

In the code, you must mention total Row number of your dataset in For Next loop.

If you want only the text part, you can remove this portion

from code.

Hopefully this will work. If you are still facing problem, then please comment with more details or the sample dataset.

Regards

Musiha Mahfuza Mukta| Team Exceldemy

Thank you, MICHAEL KAIR for your comment. As per my understanding, there is no duplicate code. Actually, I have written the code part by part with detail description. Also, in the end, I have attached the complete code for making the Date Picker. That’s why, it seems to you the code is used twice but actually, the last one in

Step 7(last code) is the complete one. You should use only that one in your module. And the other codes are for explanation purpose.I hope this will solve your problem. Please let us know if you face any further problems.

Regards,

Musiha Mahfuza Mukta,

ExcelDemy

Thank you ZOYSA for your comment. Below, I have attached two formulas for your problem.

I have written the data from the A2 cell and C2 cell. According to your question, I have considered the dataset till A10 and C10.

Firstly, write the below formula in the E2 cell or the cell from where the NAME will be started.

=IF(A2=”TOM”,C2,””)Then copy this formula up to E10 or your dataset’s end cell.

Then use another formula in the F4 cell.

=SUM(E2:E10)Thank you PHUC YU for your comment. Actually, I have tried these methods too and the methods are working perfectly. Here, you can also zoom out the Excel file directly by clicking the

Minus(-)sign situated right most corner of the file.In case of, you are using an older version than 2013 of Excel then these methods may not work. Or, if you have any bugs or issues in your laptop then these would not work. I thing you were facing a different problem which is not related to this articles.

Thank you ROB for your comment. Here,

ROWfunction is working as the row index number of theINDEXfunction. Actually, it should beROW(B2:D9)=> {2;3;4;5;6;7;8;9} which denotes respectively the 2nd, 3rd, 4th…. up to 9th row number of this ($B$4:$D$12) array ofINDEXfunction. Here, we ignore the1strow of ($B$4:$D$12) this array as1strow contains the Club Name’s not any player Name’s.On the other hand, you have to use

B4:D4row in theMATCHfunction which will search for the Club Name’s and act as the column index number in theINDEXfunction.Say, when you choose

Borussia DortmundorC4cell from the list ofC14cell then theMATCHfunction will return2and thus the column index number ofINDEXfunction will be2soINDEXfunction will give all the rows (except 1st one) of2ndcolumn of the given array which means all the player name’s of theBorussia Dortmundclub.So, you can use the formula like the below one.

=IFERROR(INDEX($B$4:$D$12,ROW(B2:D9),MATCH($C$14,$B$4:$D$4,0)),””)Hello MP ROY,

Thank you for your comment. I have tried these codes and they are working perfectly, except the code in Example3. For that particular code, you can use a new workbook. While I was using a new workbook the code has been perfectly worked there. But you have to be careful about the name of worksheet. You have to use exact worksheet number and name in the code.

Regards,

Musiha

Team ExcelDemy

Hello, J KUMAR.

Thank you for your comment. I have tried the code too and the code is absolutely right and perfectly working. But you are facing problem because most probably your device is running out of virtual memory. So, when you are trying this code in Excel, at that time you should close all other applications. Also, you should use an individual module for this code.

Hello, CHRIS.

Thank you for your comment. Actually, with the help of method 4, you are converting numbers into text. But when you re-entered any new value then the cell will hold that value excluding the apostrophe. Basically, the past value along with the apostrophe completely had gone away. So, if you want to keep the apostrophe then you should select that cell (containing new value) and run the Macros again. Then, you will see the apostrophe again with the new value.