1px

hi all.. how to make series alphabetically based on unique adjacent cell... <thead> order/desired data </thead><tbody> A apple B apricot C banana C banana D apricot D apricot D apricot etc.. avocado blackberry blackberry blackberry </tbody> my target...

hi all.. how to insert this number 5 digits <thead> entry expected result </thead><tbody> 1 LPK-00001/1/1/WKN.03/KNL.03/01.00/2018 15 LPK-00015/1/1/WKN.03/KNL.03/01.00/2018 326 LPK-00326/1/1/WKN.03/KNL.03/01.00/2018 </tbody> any helps..thanks.. m.susanto

Hi Team, Looking for some help to do the following... Data as follows: <tbody> Week Product Supply 1 Apple 0 2 Apple 0 3 Apple 0 4 Apple 5 5 Apple 0 6 Apple 0 7 Apple 10 8 Apple 0 9 Apple 10 10 Apple 0 11 Apple 0 12 Apple 0 13 Apple 0 14 Apple 0 15 Apple 5 16...

Hi Team, I'm looking for help with Power Query to achieve the following... Here's my data: <tbody> Product Type Sales Apple Bag 11 Apple Box 4 Pear Bag 7 Banana Bunch 8 Orange Bag 12 Orange Box 4 </tbody> I want to extract the records for each Product where the biggest Sales...

hi all.. how to make this use Custom Number Format : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC ; }...

I have a set of data that was given to me about 100000 rows like below. What I need to do is to count the areas but I can't figure it out. Any help would be appreciated! <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial...

Hi Team, Looking for some DAX help again! Here's a mock up built in Excel to illustrate what I'm trying to achieve (data resides in range B2:K23): <tbody> Product Key Figure 18/12/2017 25/12/2017 01/01/2018 08/01/2018 15/01/2018 22/01/2018 29/01/2018 05/02/2018 Apple Demand 5 56 45 6 25 50...

Hi again, Next problem: how to create a list of non-consecutive dates in Power Query. Source data as follows: <tbody> Dates 11/12/2017 18/12/2017 25/12/2017 01/01/2018 08/01/2018 15/01/2018 22/01/2018 18/12/2017 25/12/2017 01/01/2018 08/01/2018 15/01/2018 22/01/2018...

hi all... how to adding 0 and mark "-" without helper column... this layout : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid...

hi all. how to counting number of number with automatically.... <tbody> data after formula 1 a 1 of 5 2 a 3 a 4 a 5 a 6 a 7 a 8 a 9 c 10 c 11 d 12 d 13 d 14 d 15 d 16 d 17 d 18 d 19 d 20 etc... 21 22 23 </tbody>...

hi all... how to make this formula to calculate 2 conditions : this formula : <colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=E0E0F0"" target="_blank"></colgroup><colgroup><col><col><col><col><col></colgroup><thead> C D E F G...

Good evening I have a sample of data below. I have about 200,000 rows. I am looking for a formula or subroutine that will find the school month and calculate the frequency like below. Here is an example I would like to check Lincoln School in the SEPT column and count how many cells are 1 to 4...

Hi, I am having trouble working out how to construct a new table based on the elements of an existing table. I'm pretty sure it's a combination of VLOOKUP and MATCH but he could also use INDEX. Here is the master table: <style type="text/css"> table.tableizer-table { font-size: 12px...

Hi, I have repair shop that buys large amounts of used bikes and then repairs them, and after repair is done sales repaired ones to buyers. I know how repair success is distributed over months, and I know how sales of repaired bike since it is placed into store is distributed. I would like to...

Good afternoon, I have data based on 2 columns column B and E. What I would like to do is to highlight the group in yellow if the name and the DOB match. For instance AAAA and DDDD would be highlighted in this example. Thanks in advance!!!!! <style type="text/css"> table.tableizer-table {...

Dear All, I have a worksheet like this- <tbody> TYPE NAME A Rachell Rivard A Fatimah Tay A Zane Crowley A Hermine Elsner B Leigh Ortez B Priscilla Michie B Ken Cardiel B Mack Zheng C Ruthe Lanz C Neida Gallivan C Sherry Barrientez C Sondra Schrage </tbody> Now, I...