Hi All,
I have company names in column A and there counts in column B. I need to expand the companies according to the count mentions in columns B. Please find the attachment.
Hi All,
I have company names in column A and there counts in column B. I need to expand the companies according to the count mentions in columns B. Please find the attachment.
Try
![]()
Please Login or Register to view this content.
Please try
![]()
Please Login or Register to view this content.
If you are interested in FORMULA solution.
ARRAY formula in F2 then copied down till blank cells are seen.
To enter ARRAY formula![]()
Please Login or Register to view this content.
Copy and paste the formula in cell
Press F2
Press Ctrl+Shift+Enter together
Excel covers the formula with {}.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thanks. I got what I was expecting it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks