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

I

Ivan3720202020-08-18 00:53:26

It is necessary to create a database for an enterprise with sales results, what software? 1Reply

A

Alex May2014-02-22 14:58:35

XLS passwords: how to remove them? 1Reply

S

Sergo832021-12-02 11:29:21

How to set the sheet name in the formula, taken from the text in the cell? 1Reply

R

Rudy9962020-08-24 20:07:53

How to make a linked drop down list with prices? 1Reply

M

mUchenik2020-08-27 09:58:59

How to set up automatic updating of the refinancing rate? 0Reply

Didn't find what you were looking for?

Ask your question