part

OK, so I have a drop down in cell A1 to select the year and another dropdown in B1 to select the first part of a filename and a third dropdown in C1 to select the second part of the filename So if select... A1 = 2019 B1 = Donors C1 = April ...and the file I want to open is...

This is a two part question. Have a report with an apostrophe in front of a series of numbers. The first part is to remove the apostrophethen the second part is to find a specific two digit number within the seriesof numbers. Reading the series right to left in two digit format. There is a...

Hello I want part of the text below 1398/12/30 in a cell with a format or code or any other tool ... I would say exactly 30 so that the text of 1398/12/30 is shown in the formula bar. Thank you

Hello I made a data table and it generates DIV errors. Are there any limitations when using data tables? How do we specify the formula we want to use? My formula is: =MIN($C$8/(C4*INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+1,'Part 2'!$C$26:$AS$26))+C4*(1+INDEX('Part...

Hello, Need help.... Collum x is 20 then 20*6.84 but if its above 20 and bellow 30 then 20*6.84+10*4.56 (this part i got it) BUT!!! If above 30 then 20*6.84+10*4.56+(whatever above 30) *1.5 Ex: 45 20*6.84+10*4.56+15*1.5 What I got so far...

Hi I'm wondering if anyone can help with an issue I just can't seem to solve. I'm trying to use a nested IF OR statement to show a value in a cell from another sheet: =IF(OR(F7,F9,F11=Lists!A1),Lists!C5,IF(OR(F4,F7,F8,F9,F10,F11=Lists!A1),Lists!C6,"")) The first part of the statement works...

Hi, I have a time window for what is considered a night shift, e.g. 0000 - 0559. These times can change wither before or after midnight. I want to supply a start and end time of a numbers of shifts and see if any part of those shifts falls within the hours above. I had tried this formula...

Hello, everyone, please for your assistance. I have made a VBA form in which there is TextBox1. I want to write something to find it in the selected worksheet named "Base" and column "P". (this part is most difficult for me to do). I mean - Text Filters -> Contains I would be very grateful if...

Hello all, I have several databases that hold different segments of an items history. 2 of these databases have parts of the information. I run this in Access and I get a table with my specs. I need to export the Excel file of this and then attach the database to update the query. When I...

Looking for a lesson and a solution using VBA. I have about 123 lines of part numbers, the first line always starts at F13 and never sure on when the last line will be. I need to sum each unique part number and then create a table showing the quantity of each unique part number found...

Hi, want to create a macro to filter all cells in column K, which include the word "VAT Return". The name vat return will be part of a string: For Exampe: Q1 2019 VAT return, or Q2 2019 Vat return. Sub filtering rows("1:1").select selection.autofilter activesheet.range("k4:k100").autofilter...

I am trying to create a price list and the vendors part numbers and descriptions are different that our database. I would really prefer not to go through thousands of items one by one and change them. Is there a way to use a partial reference system? =Index(Match) =if(VLOOKUP) <tbody> My #...

I am trying to find a formula that allows me to do the following in order: 1) If the group ID is the same AND (2) if the Part # is the same as the (3) Part # with the minimum group price, highlight this. For example below, I want to highlight part # MPN1 because it is has the same GroupID and...

In column A I have a distinct part number. In two other columns, i have that same list of parts, but it is not unique in the lookup table. each instance will have a different value in the 2nd column. One part in Column A may exist 3 times (or more) in the look up table. In column B, i want the...

In column A I have a distinct part number. In two other columns, i have that same list of parts, but it is not unique in the lookup table. each instance will have a different value in the 2nd column. One part in Column A may exist 3 times (or more) in the look up table. In column B, i want the...

Hi I'm writing an Add-In so people in my team can copy charts automatically to PowerPoint or Word. I just tested it on a file where one of the charts has text boxed and an arrow grouped together - these will need to be copied together. First, How do I tell that the chart is part of a Group. I...

I've inherited an Excel document that is used to keep track of where materials are located within out facility. Recently they asked me to include quantity counts and mark them red when quantity gets low. This part wasn't hard, simply used a <count-if> function, then set conditional formatting...

Mr Excel, I am trying to pull a dependent part number based on its assembly level in a bill of material. Here is the bill: <colgroup><col width="65" style="width: 65pt;"><col width="104" style="width: 104pt;"><col width="82" style="width: 82pt;"><col width="114" style="width...