show

  1. Q

    Comparing multiple versions of the same workbook and display results - advice

    We have a workbook with column A1:A100 containing different company names. B1:AA1 contains multiple products and services. Each company has the relevant data (versions, dates) filled in about each product or service. This could be in the form of a a number, text or date formatted cell...
  2. A

    sum data of two table in two sheets

    hi, expert i have table contains data in sheet1 the range from a1: d6 and the sheet2 the same thing and theyare both contain repeated data what i would code show the data in sheet2 the range from h2:k6 with sum the duplicated data and show one time without repeating
  3. P

    Convert the order the first and last name is written via formula

    Hi assuming I have "Driver Name: Donald Williams Jr" in Cell A1 in B1 I am looking formula that will show "Williams Jr, Donald" ...not sure if that is possible so the other option is in B1 have just "Donald Williams Jr" then in C1 "Williams Jr, Donald" thanks for the help.
  4. D

    vlookup a date from pivot table, can not add days to it and show date

    Hey Pros, I use vlookup on a DATE from array "=VLOOKUP($CB5&COLUMNS($CC$4:CC4),$BY:$BZ,2,0)", locate in (CC5), and I want another cell (CI5) to be (CC5 10 days later ), but function =CC5+10 will show #value ! error , please teach me on how to do this correctly. Thank you
  5. B

    Msgbox question

    Hello all, My msgbox is not working. Would like to show a message, show the Information icon and add values from variables in 1 msgbox; If xEptTxtName <> "" Then MsgBox "The following required fields are not complete", vbInformation & vbNewLine & xEptTxtName & vbNewLine & xTxtName...
  6. R

    Data validation - dynamic and also dependent on a particular column

    Hi, Please refer to the image in the link below. I’m trying to create a data validation that lets a user choose Product and Colour of a car from the Manufacturer. Is there way to put some function in data validation list option so that it looks for Audi on the worksheet and takes the...
  7. M

    Show result based off indirects

    Hi, I have a series of lists based off indirects, all to get me to a final product code. Now i have the code i want to show its current location. It can be in one spot, in many spots, or in no spots which will spit out an error ("no location found") I have the list K9:T292 for the locations...
  8. H

    Macro: Auto Fill down on Col A & B base on cell

    The pic1 show original, and the marco will auto fill down as show in pic2 (yellow)
  9. D

    Most common number that follows a specified value in a list

    I want to enter a formula in cell B1 This formula will show the MODE of the values in a range that follows a specified number in C1 E.g. If C1=10 Then B1 will show the mode of numbers that follow 10 in a range B2:B10. Which would be 5. If C1=5 then B1 would equal 4 eg B2=10 B3=5 B4=4...
  10. D

    Most common number that proceeds a specified value in a list

    I want to enter a formula in cell B1 This formula will show the MODE of the proceeding values that I specify in cell AI E.g. If A1=10 Then B1 will show the mode each number in a range B2:B100 that proceed a 10
  11. M

    Special symbols/font in data validation

    I have a specialist font for garment care symbols (Medium iron, do no wash, dry clean only, etc) which I need to show in a drop down. The font I have installed shows the actual symbols in the cell but when the drop down is clicked it shows the alphanumeric characters (t, f, x ,!, etc). Is...
  12. S

    Dates every 15 min show a Reference number

    Hi Guys I have a Column A with dates & times eg: ( 2019/08/11 06:00 ) running, for example, continues for a number of days. In Column B I would like to show a numerical number starting from 1 .... every 15min. So example from 19:12 to 19:27 column B with show a 1 then from 19:28 to 19:43 will...
  13. L

    Product Totals

    Hi please see the photo in the link; https://ibb.co/RPmLYTz Is it possible so that A16:A24 will display a product code and C16:C24 will show the total amount of each product?
  14. M

    show zero value

    <colgroup><col width="101" span="6" style="width:76pt"> </colgroup><tbody> POINTS BAGS WIN WE WE THEY TOTAL WE LOSS TOTAL 392 568 ($17.60) ($4.00) ($10.00) ($63.20) 551 427 $12.40 ($4.00) $10.00 $36.80 576 378 $19.80 $12.00...
  15. A

    show the colored value of column in listview

    hi, everyone i have data in sheet1 from range (a:d) , userform contains listview and the column d containes values of colored green and red i would show the colored value of column in list view is there any code do that ?
  16. R

    Drop Down depencies

    <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Cars TYPE MODEL Hyundai h1 I20 Hyundai h1 I10 Hyundai h2 I30 Hyundai h2 I40 Suzuki S1 WHITE Suzuki S2 black Suzuki S3 PINK </tbody> If I select...
  17. D

    Using IF formula to "find" 123456 in INV123456

    https://1drv.ms/x/s!AvjBsEPEq12ngTWjooUrD2AsRCFa?e=myH4Mi I am doing an IF formula to see if A1 equals any of the values in C1:C3 =IF($C$1:$C$3="*"&$A$1,"Yes","No") When I hit F9 to evaluate the red part of the formula, it shows an array of FALSE's Ideally, I want the array of results to...
  18. C

    IF Condition help (I believe)

    Good morning Mr. Excel community, I have a questions and wondering if you can help! <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}tr...
  19. sijpie

    weird cell behaviour with multiple lines in cell with restricted height

    I am working on a workbook for someone. The workbook is to schedule people in a duty roster. As the number of names is large, there is a big possibility of two or more people with the same name. That is why I want to store the ID number in the cell with the name. For clarity on the screen I...
  20. F

    Show first item in data validation dropdown

    Hello, I did use formula right in the cell before. But If I remove other info the formula will be removed, so I decided to use data validation lists instead. I'm having =INDEX(OFFSET(BusinessNameStart;MATCH(D3;BusinessNameList;0)-1;2;COUNTIF(BusinessNameList;D3);1);1) So, this one will find...

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