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

J

John Smith2021-04-09 21:05:21

Formatting percentages in Excel so that the % symbol is to the right? 1Reply

S

Sergey2017-05-02 16:57:20

How to expand a formula into a column with merged cells in excel? 2Reply

O

OlyaL2015-05-29 12:01:32

Why doesn't Xls print the selected page range at the bottom of the sheet? 1Reply

I

IgorK-dev2019-10-18 16:50:02

What options are there to display only nested excel records from one paragraph on the page? 1Reply

A

alexq22015-06-05 10:19:04

How to fix Excel from single window? 0Reply

Didn't find what you were looking for?

Ask your question