Guys I need help
I need a formula for a column
If any values in the column are the same they get highlighted
Thanks in advance
Guys I need help
I need a formula for a column
If any values in the column are the same they get highlighted
Thanks in advance
you can do conditional formatting. just select conditional formatting in the tool bar -> highlight rules -> duplicate values
Guys I need help
I need a formula for a column
If any values in the column are the same they get highlighted
Thanks in advance
or you can do a countif formula (but it won’t highlight by default)
you can do
=COUNTIF(Column:Range,FirstCell)
for example:
=COUNTIF(A:A,A2)
then auto fill down
the result will be a count of how many times the value in the current row appears in the range
This was me, but know that I'm a team lead, I ask my reports to make spreadsheets for me
https://vm.tiktok.com/ZMRqkKFnF/
so many hot keys lol i need to start writing them down
kelly rowland was ahead of her time
dead at this, like how you texting someone from excel
dead at this, like how you texting someone from excel
she thought she was flexing
https://vm.tiktok.com/ZMRqkKFnF/
Read through the lines
There's a reason the boss doesn't know hotkeys while the salaryman does
https://vm.tiktok.com/ZMRqkKFnF/
literally have this video saved in my phone
i love excel, seeing columns and rows just fill up without you doing any work
i thought it was just an app for work and school bc im studying Accounting but I'm using it to track my personal expenses and subscriptions and daily calorie and vitamin intake, track weight loss
i wish they released it for the Nintendo switch
What else can you do it on it
Excel/Sheets is GOAT for budget tracking
op spitting straight facts.
I do my finances at the start of every month and I keep adding new graphs and projections and s***
too brazy
Excel is not fun if you work as an IT