User Profile
sonbarse
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Missing Numbers between two ranges
Dear Expert. I need to locate the missing numbers for the range in the subsequent columns. The highest number is in Cell B2 & Lowest in Cell A1 & expecting answers in Cell C2, D2, & so on. Similar next range highest number is in Cell B3 & Lowest in Cell A3 & expect answers in C3, D3 & so on. Sample Excel sheet attached. I am able to get the results if the range is static, but in my case for each row there is new range & hence same formula cant be used. Please advise.802Views0likes1CommentMultiple Answers for Unique Value
Hi. I have multiple skill assigned for every extension in the contact center. Need assistance on formula to have all the extensions to which the skills has been mapped. Attached workbook with Master Sheet & Answer Sheet. Example : The master sheet has Skill 3918 assigned to various Extensions. How to get all those extension number mapped to skill 3918 and so forth for remaining skills as mentioned in the answer sheet. Thanks in advance for expert.Solved928Views0likes2Comments
Recent Blog Articles
No content to show