excel tips

  1. A

    How/which formula can be used to lookup a value in a table and return multiple matches in table format In Excel?

    I have a dataset like below when I select Department from the Dropdown I need to return multiple matches in atable format like below Which Formula can i use to get these multiple matches in a table format....Thanks in advance
  2. 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 .......
  3. K

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

  4. K

    Party name According how many invoice to Show count , But Not Show count Total Invoice

    Show Result : 3 (Pleased Show this Query........................................)
  5. K

    # How to Hide Row According to "Zero"

    Pleased make this VBA script ...... Find to Zero value on row & hide this row
  6. K

    How to count "Same Purchase item Qty total" and "minus Same Sale Qty total " ??? make report

    How to count "Same Purchase item Qty total" and "minus Same Sale Qty total " if Qty balance is "0" , not show entry in report Again.
  7. K

    Query: How to count same party with unique Invoice numbers....

    like ... "SR FOODS LTD" two time make Purchase products. 1) how to count target Unique Invoice Number & same party Name ???????????????????????????????????????????????
  8. K

    how to find particular text on cell

    EX: A1 cell EXP/089/20-21 # i try to find particular word to alert condition # find : /20-21 (this word fount to alert to other cell , "ok","Not"
  9. K

    # Condition is - How to highlight Cell Value via other cell "TRUE" OR "FALSE" value (if "K1" = FALSE after change cell color to Red) (No VBA)

    @ How to change "H2" cell color change After "FALSE" ????????????????????????????????????????????????????????????????????????????????????? (No VBA only for condition formatting)
  10. K

    @ How to lock cell after click check box tick mark?

    Kindly Find Result....in Above Question...
  11. S

    List need to arramge

    Hi I have a list of data which i Got from pivot table which is given below and i want those data in different format. Please help Place Name USA John Rohan Alex Roxy India Rahim Sourav Bikram I want previous...
  12. K

    Formatting Excel Texts and Values

    Hi! I have a Form to be filled and i receive the data as .txt files, hence have to convert data from txt to excel format for the ease of copying to my target form easily. Now i have managed to convert the file to excel, but certain formats are really confusing. I would be grateful if someone...
  13. J

    Recommended Excel knowledge for an administrative assistant?

    Hello, everyone! I am training myself to be a proficient administrative assistant, and I am looking for some advice from experienced Excel users as to what they believe would be the most useful Excel knowledge for my job level. Many job postings for this type of position require advanced...

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
Top