IT

ALL IT Technology Information

Microsoft Excel

 Microsoft Excel


===========================

to auto filter to index mirror data find to show  

Now, assume we have the number of product selected in cell I3. Given this, we can calculate picked product’s quantity using a simple INDEX formula:

=INDEX(data1[@[Soap]:[Deodorant]],$I$3)

======================

my (=INDEX(Table5[@[a]:[d]],$F$2))

to use $F$2 to use only this box value count 

=====================================

x lookup sum error to solve 

this excel sheet table type data in combine data for month and deterrent price monthly 

1st filter to  product name to latest data fiend 

=MAXIFS(D5:D28,C5:C28,H5)   

D5:D28 =select date 

C5:C28 = Select product name 

H5 = call to product name to fiend

                   

    2ed fiend value of product

       =FILTER(E5:E28,(C5:C28=H5)*(D5:D28=H12))

          E5:E28 = product price 

         (C5:C28=H5) = (all product name select all = finder product box select )

        (D5:D28=H12) = (all Date column select = your latest data box select )

 

                

    same 2ed type to solve 

    =XLOOKUP(1,(C5:C28=H5)*(D5:D28=H12),E5:E28)

     (C5:C28=H5) = (all product name select all = finder product box select )

     (D5:D28=H12) = (all Date column select = your latest data box select )

    E5:E28  = all price columns select               


 =====================================

BEST tips & tricks 

you type 1 to 100000 value in columns one click not a scroll put down

 go to home > fill > series > > open new windows to show series in check columns

input value you need step value 1 : stop value 100000 ok 



=====================================

down photo in see store1 4,3,2,5 not a series number how to set series number

To move any columns to first select and see this photo , arrow + symbol to press shift + Right click  and   move your arrow


and see this option to shift right and move then your columns move to

                          


                                      

===========================

 This Table data in store ,region ,total 

you count multiple ares in region to you fiend value total 

to use in multi times in use ares and value sum  .

              =sumifs(tblsales[Total],tablsales[region],B3)

    tblsales[table] = table name  [table header name]

B3 is area name , witch area you find value of sum

==================================

    you create auto link table data  insert to file

                               to simply select your table and right click  load to ...

                       to select table option then ok
            side bar in show your all table data name to insert you sheet

                         how to show this option to first go to 

                        Data > Query options > Data load > Default Query load setting > select specify custom default load setting  ok 

then you see side bar in all data table show  

          you formulas you use like =C2*105% and this answered to scroll put down how to next tips 

to you use =C2:C79*105%   = auto all value full fill all box in columns  

             ========================

you define unique vale find mins same value find to user 

=UNIQUE(sales[product])

all filer and duplicate value remove and filter data unique value name                                   


then you sum only unique data to use this formulas 

=SUMIFS(sales[units],sales[product],H5#)

 

 to use one screen in 2 excel data sheet to use this option 

go to View > Arrange all > vertical 

ok

  like this
========================================

3 comments:

  1. Great and supporting culture for employees. Management is really super active and think about their employees, so as of now none.

    Amazing salary and perks for all the employees, there are great work ethics. You will not be disappointed with your decision of working for this company. There is no partiality at all

    ReplyDelete
  2. Great and supporting culture for employees. Management is really super active and think about their employees, so as of now none.

    Amazing salary and perks for all the employees, there are great work ethics. You will not be disappointed with your decision of working for this company. There is no partiality at all

    ReplyDelete
  3. this site
    https://www.fm-magazine.com/issues/2019/jun/100-tech-tips.html

    ReplyDelete