• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Array
#1
Hello All here,

Greetings,

May I request you all to please help me the way to get the result as shown in column 'E' from the column 'A' and 'C' dynamically in attached sheet.

Thanks in anticipation.


Attached Files
.xlsx   Test FIH.xlsx (Size: 10.37 KB / Downloads: 9)
  Reply
#2
It can be easily achievable through VBA. Kindly let me know if you want to get it done through VBA.

We have relocated this club to a private Facebook group. Kindly join there and ask your queries from next time.

https://www.facebook.com/groups/FutureInHandsClub
Regards,
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile
  Reply
#3
(11-Jan-2020, 01:11 PM)Abhay Wrote: Hello All here,

Greetings,

May I request you all to please help me the way to get the result as shown in column 'E' from the column 'A' and 'C' dynamically in attached sheet.

Thanks in anticipation.

only with array I will do so please give me some time thank you and I need more challenges like this
  Reply
#4
(12-Jan-2020, 09:01 PM)Vivekananda Sinha Wrote: It can be easily achievable through VBA. Kindly let me know if you want to get it done through VBA.

We have relocated this club to a private Facebook group. Kindly join there and ask your queries from next time.

https://www.facebook.com/groups/FutureInHandsClub

Thanks, Mr Sinha!
This is not so much required, I was just wandering if it can be done through Excel only. In fact this is only small part of a project  I am working on, I sincerely wish I'll finish and apprise for your rating and commendation, and valuable advise. 

Please, pardon me for taking this as opportunity to thanks your from bottom of my heart- YOUR ALL VIDEO AND KNOWLEDGE I FOLLOW AND BEING PROUD THAT I ALSO KNOW EXCEL. 

Thanks you so very much for making a strengthen working society.

Regards,
  Reply
#5
(11-Jan-2020, 01:11 PM)Abhay Wrote: Hello All here,

Greetings,

May I request you all to please help me the way to get the result as shown in column 'E' from the column 'A' and 'C' dynamically in attached sheet.

Thanks in anticipation.

I attached solution for your query and check and let me know


Attached Files
.xlsx   function to extract values.xlsx (Size: 12.98 KB / Downloads: 1)
  Reply


Related Topics
Topic Author Replies Views Last Post
  Formula Sumif with array Amit sharma 2 2,106 17-Nov-2018, 10:40 PM
Last Post: Amit sharma
  Formula #Rank#len#array Amitg9595 2 1,968 07-Oct-2018, 08:11 PM
Last Post: Amitg9595
  Formula May be "Array" PRADEEP RASTOGI 1 2,058 22-Jan-2018, 10:33 PM
Last Post: sanj_edu
  Formula Calculation By array formula Sanjeev Singh 2 2,057 06-Nov-2017, 01:06 PM
Last Post: Sanjeev Singh

Forum Jump:


Users browsing this topic: 1 Guest(s)