Hello friends I’ve attached a wonderful excel sheet all options and formulas in an excel sheet. Hope it helps you.
From India, Madras
Acknowledge(43)
Amend(0)
54From India, Madras
Acknowledge(43)+38 more
Amend(0)
Hi Kavitha,
Your post is excellent. I have a few doubts in it. The below function is used in RANDBETWEEN:
{=IF(SUM(1/COUNTIF(E24:E30,E24:E30))<>7,"Duplicates! Spin again","All OK")}
You have mentioned CTRL+SHIFT+ENTER to be used to insert an array. I am not getting it. Can you guide me on it?
Manikanth
9291683603
From India, Nizamabad
Acknowledge(0)Amend(0)
Your post is excellent. I have a few doubts in it. The below function is used in RANDBETWEEN:
{=IF(SUM(1/COUNTIF(E24:E30,E24:E30))<>7,"Duplicates! Spin again","All OK")}
You have mentioned CTRL+SHIFT+ENTER to be used to insert an array. I am not getting it. Can you guide me on it?
Manikanth
9291683603
From India, Nizamabad
Acknowledge(0)Amend(0)
i told u tat nobody will touch ur excel File unless and untill u put ur hand Down....... :-D:-D:-D:-D:-D:-D:-D:-D:-D
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Kavi whenever i click on any icon it throws an error that protected cells cannot be modified..........Can u re-attach the file.
From India, Madras
Acknowledge(0)Amend(0)
0
0
From India, Madras
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The error message indicates the Excel sheet has protected cells preventing modifications. To resolve, unprotect the sheet or provide instructions. (1 Acknowledge point)
0
0
All you need to do to practice on with the formulas given here is, you need to select the entire sheet and copy-paste it in another workbook for practising.
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
This spreadsheet does not need a password. I have opened it on my computer and can easily read all the examples of formulas to use in any spreadsheets I may wish to create. This is just a guide to show how to use various formulas. Use it as that to develop your spreadsheets.
From Australia, Melbourne
Acknowledge(0)Amend(0)
From Australia, Melbourne
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Formulas.xls
Excel Formulas.ppt
CiteHR.AI
(Fact Checked)-The array formula in Excel requires pressing Ctrl+Shift+Enter to work, not just Enter. Try that to see if it resolves the issue. (1 Acknowledge point)