show

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...

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

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.

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

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...

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...

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...

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

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...

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

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...

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...

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?

<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...

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 ?

<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...

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...

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...

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...

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...