Excel counting high scores?

I

Igor Gafarchik2021-12-11 13:10:02

excel

Igor Gafarchik, 2021-12-11 13:10:02

I have a table of statistics of COVID19 cases. In this table, I need to calculate the number of anti-records (the new largest number of cases per day), how to do this? Maybe there is a formula?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

H

hint000, 2021-12-11
@hint000

=MAX(B$1:B3)
=IF(C3>C2,1,0)

Similar questions

M

Max Trophy2016-11-24 09:40:30

How to keep region pinning in imported excel report from Report Builder (ssrs)? 1Reply

V

Vladimir Krysikov2014-12-03 15:01:45

How to transfer formulas to Excel in Fastreport for .NET? 0Reply

D

Dmitry2016-12-02 23:33:27

How to make the text color red in LibreOffice Calc (well, or Excel) if the value is less than 100%? 1Reply

E

Evgeny Matveev2019-05-02 07:18:19

How to display data from another workbook in Excel? 2Reply

V

Valentine2016-12-09 11:21:51

How to quickly create a complex Excel document? 3Reply

Didn't find what you were looking for?

Ask your question