I've been promoted!

let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

Walking the tightrope between genius and eejit...

Notice my main language is not English.

I appreciate it, if you reply on my solution.

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star * add reputation.

Regards

Fotis.

-This is my Greek whisper to Europe.

--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

Advanced Excel Techniques: http://excelxor.com/

--KISS(Keep it simple Stupid)

--Bring them back.

---See about Acropolis of Athens.

--Visit Greece.

Click * below if this answer helped

Advanced Excel Techniques: http://excelxor.com/

Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

...enjoy -funny parrots-

Remember what the dormouse said
Feed your head

_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros

If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]

?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)

If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

You can't do one thing. XLAdept

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved

"Nothing is so firmly believed as what we least know."
--Michel de Montaigne

Regards,
Vikas Gautam
Excel-buzz.blogspot.com

---

Excel is not a matter of Experience, its a matter of Application.

---

Say Thanks, Click * Add Reputation

Audere est facere

Sub DontForgetThese()
     If Your thread includes any code Then Please use code tags...
     If Your thread has been solved Then Please mark as solved...
     If Anybody has helped to you Then Please add reputation...
End Sub

If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved

If the suggestion helps you, then Click *below to Add Reputation

Regards
Sean

---

Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!

"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

Use code tags when posting your VBA code: [code] Your code here [/code]

Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

Last edited by Speshul; 09-09-2014 at 02:41 PM.

You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas

Originally Posted by Jacc

Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.

Click the * below on any post that helped you.