hivebuzz (74)in Excel For All • 4 years agoRE: [Solved] Question on Conditional data validationCongratulations @angelak! You received a personal badge! Hive Birthday! You are on the Hive blockchain for 1 year! You can view your badges on your board And compare…paulag (73)in Excel For All • 4 years agoRE: [Solved] Question on Conditional data validationassuming you are adding data validation to cell A1 =MOD(A1,5)=0 Replace cell A1 with the cell you want the data validation inhivebuzz (74)in Excel For All • 4 years agoRE: [Solved] Question on Conditional data validationCongratulations @angelak! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) : You received more than 50 upvotes. Your…paulag (73)in Excel For All • 5 years agoRE: Need Help - How do I do this?Hi @angelak, can you please confirm if this has been solved and edit the post title accordinglyxlncad (46)in Excel For All • 5 years agoRE: Need Help - How do I do this?If your data is supposed to change you should go for an Array formula using TRANSPOSE function. The array formula for the example shown in the screenshot is…theexcelclub (67)in Excel For All • 5 years agoRE: Need Help - How do I do this?Hay @angelak and welcome to the community. Let me try and help you. Changing the data from rows to columns or columns to rows is known as transposing If you copy the data…steemitboard (66)in Excel For All • 5 years agoRE: Need Help - How do I do this?Congratulations @angelak! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) : You published your First Post…theexcelclub (67)in #excel • 5 years agoRE: Stop! Do Not Merge Cells in Excel - Heres why with fixesI'm glad to hear you liked it @angelaktheexcelclub (67)in #excel • 5 years agoRE: XLOOKUP V's VLOOKUP - 8 Limitations RemovedI believe it is not backward compatible and will only be available in 365theexcelclub (67)in #excel • 5 years agoRE: Rich Data Types in Exceloh animal or plant species would be interesting indeedtheexcelclub (67)in #excel • 5 years agoRE: These Excel Tricks Make Ordinary Users Look Like Data WizardsMicrosoft is moving fast thats for sure.