easy excel tricks

  1. K

    How Get Question Reference

    (1) How to get reference Sheet 1 to Sheet 2 (2) We Need four Option Reference According Match Question on Sheet 1 *Kindly make this formula for "sheet2" Condition 1 :- i will change Serial Number After Change Question in "sheet 2" (match Serial no. and question to "sheet1") Condition...
    • krunal123
    • Thread
    • #excel #file error #excel #formula #confused #excel #pivot #formatting #datalabels #pivot tables #tables conditioanl formatting easy excel tricks exce formula excel & countifs excel & formula excel & if excel formula macro
    • Replies: 0
    • Forum: Excel Questions
  2. K

    Get SUM Total After Target ROW Via Formula ????

    • krunal123
    • Thread
    • #cells #autoaupdate #date #chart #conditional formatting #excel #comparison #excel #formula #confused #excel #pivot #excel formula #excel query #excel#sum #pivotable #sum #if easy excel tricks
    • Replies: 1
    • Forum: Excel Questions
  3. K

    Make One Dropdownlist , Including all table Column Cell Details Show without Dependent Dropdownlist ?

    @ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...
    • krunal123
    • Thread
    • #conditional formatting #excelguru #excelquery #excelquestion #filter #powerquery advaced filters easy excel tricks excel & formula excel & ilogic excel & lookup excel & lookup & search excel formula help vba & conditions
    • Replies: 5
    • Forum: Excel Questions
  4. K

    @ How to match Two condition & show value ???? via formula

    @ How to match Two condition & show value ???? via formula 1 st table to match 2nd table data , Need Both Condition Match (1) Invoice No. (2) CHA , And Get Result After match 1st table
    • krunal123
    • Thread
    • #chart #excel #comparison #excel lookup #find and replace text #matching #searching #pivot table#fiilter easy excel tricks excel "multiple strings" excel & formula excel & ilogic excel questions excel reference
    • Replies: 1
    • Forum: Excel Questions
  5. K

    How to use dropdown list according Two or more different Tables ???

    Query : " HOW TO COMBINE " ITEMLIST " & USE IN DROPDOWN LIST (Condition : Inclued Both table "Item list" * Both Table "Item list is different * BOTH TABLE ITEM LIST SHOW ON MY DROP-DOWN LIST . HOW IT POSSIBLE THIS ????? KINDLY SUGGEST RIGHT WAY TO SOLVE THIS QUERY. Note: I was make...
    • krunal123
    • Thread
    • #advance excel #advancedfilters #excel #comparison #excel #discrepancies #excel #formula #confused #excel query #excel tips #excel tutorial #excelguru #pivot table#fiilter #power query #query #table #table formating #vba easy excel tricks excel & ilogic
    • Replies: 4
    • Forum: Excel Questions
  6. K

    How to make Automatic serial number with text ????

    How to make Automatic serial number with text ???? Basic = A1+1 =2 Next level : 1) India Combination with text Kindly Help me.....
    • krunal123
    • Thread
    • easy excel tricks excel & formula excel & ilogic excel & lookup & search excel auto fill exceltipes pivot table
    • Replies: 3
    • Forum: Excel Questions
  7. K

    How to use multiple criteria using to conditional formatting ??? (Condition is cell value After Zero Highlight Cell in RED color ?

    * how to Apply Condition Formating in Particular Cells At a time, (Condition : IF then " Available Qty " <1 to Highlight Cell is RED color). * This condition Apply but Not properly Working , Pleased help to solve this query, I try to use Multiple criteria using this condition formatting.
    • krunal123
    • Thread
    • #advance excel #excel #formula #confused #excel export #excel guru #excel query #excelquestion #pivottable #vba #issearch #formula condition formatting database check easy excel tricks excel & formula excel & ilogic excel & lookup & search filter advance criteria formula #explaination
    • Replies: 2
    • Forum: Excel Questions
  8. K

    how to Apply Condition Formatting in Particular Cells At a time ??? (Rules : " <1 " Highlight Cell color to RED After Zero .)

    • krunal123
    • Thread
    • #conditional formatting #excel tutorial #pivottable #power query #vba easy excel easy excel tricks excel excel & ilogic logic formula
    • Replies: 1
    • Forum: Excel Questions
  9. K

    We Need Only TEXT Contain, How to possible in Excel Formula ????

    All Number list is Same Len ,if Number After Single Space , We Need Only TEXT Contain ,How to possible in EXCEL formula .......
    • krunal123
    • Thread
    • @excel questions advance formula condition formatting easy excel tricks excel formula excel query excel tips excel tutorial pivottable power query advance vba
    • Replies: 3
    • Forum: Excel Questions
  10. K

    How to Pull data One file to both file ????

    How to Pull data One file to both file ???? I try to Pull data "Master" File To "Local" & "Export" File .......... I don't Know ???? How to possible .......Pleased send us Formula in excel..
    • krunal123
    • Thread
    • easy excel tricks excel excel query excel question excel tricks pivotable vba
    • Replies: 1
    • Forum: Excel Questions
  11. K

    How to match same invoce no. & get data "FILE -1" TO "FILE -2" ...

    • krunal123
    • Thread
    • # new post #excel #excel vba advance excel easy excel tricks exce excel & lookup excel advanced excel formula excel tips fiter pivotable power query vba
    • Replies: 3
    • Forum: Excel Questions
  12. K

    How to trace 2 Digit And Highlight Cell , Different Number to change Different Color Highlight. ?

    Query : How Set Different Number to Different color Highlight (like a same number Group Show in same color) Number match perfect & Smart..........pleased Solve it Conditional...
    • krunal123
    • Thread
    • condiational formatting easy excel tricks excel formula filter advance vba
    • Replies: 1
    • Forum: Excel Questions
  13. D

    Change borders/gridlines of cells in rows A, B, C & D when cells in row E contains no blanks

    Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...
    • David77
    • Thread
    • border border auto format code & formula coding error colors conditional format easy excel tricks excel gridline help ! vba "&"
    • Replies: 3
    • Forum: Excel Questions
  14. Y

    Change Default Color Palette 2016

    I know this is super easy for most of you. The question is how to change the default color palette theme. Currently I can make the proper changes I want, but it reverts back the next time I open Excel. Thank you,
    • yojeff
    • Thread
    • change color default easy excel tricks palette
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top