display

Hi, I am trying to utilize a pivot table to sum up retroactive payments due to employees. This is taking place for about 2 months back and so obviously you will see multiple line items per employee. I want to just be able to copy and send the pivot table data up to the team that handles the...

I need a formula for cell D2. I apologize but not using excel frequently I have lost so much knowledge I had before with an IF/THEN statement. I'm making a spreadsheet (simple) with B2 being a validation cell with LIST. In the list are the following... TAGS - Metal Detectable Hardback TAGS -...

Hi Community, Been trying to figure this out all morning. I have a range of data, with column headers. I have computed values based on certain criteria in a range of cells Similar to the following: Lets call it clothing items. Mon 400 Tue 300 Wed 6 Thur 7 Fri 50 I...

I have a large data set - 1,600,000 rows. I am using powerpivot so I can use all the data set. The pivot table itself however is still limited by the 1 Million lines. Most of the time this is not an issue. However I have one report where I want to display in the pivot itself more than the limit...

If I have a date in Cell A1 and I want to get the start date of the next week, how is that possible? So: A1 shows 7/26/2019. I want B1 to display 7/29/2019 (week begins on Monday). I know it is some combination of WEEK and DAY but not sure how to do it.

I have a table on "Sheet2" where you input a letter and state where it goes in "Sheet1"; A1, A2, A3 etc. in the first column and the letter goes in the second column. This table accepts duplicates and would look like this: <tbody> A1 Z A2 Z A3 X A1 X A2 X </tbody> I would like this...

I created a table to record ordering items, and have 2 columns (a Date, and a Qty) for each week of the year, per quarter, to record the Date Ordered and Quantity Ordered. I have 2 columns (at the end of each quarter) which I want the Last Date Ordered to appear in one column, and Last QTY...

Hi Experts, Could you please help me complete this formula? I am looking up a value in one sheet, and if it is found then display it, if it is not found, then lookup in the second sheet, if it is found display it, and then so on and so forth. The example I have so far is...

I do have 3 series in a stacked bar chart. The fourth series is a data label displaying the date. I need to display different color for the label based on a column that as Yes or No values; ie., display data labels in red color if it satisfies Y and display in green if it satisfies No. How to...

I've got a sheet that works out the lower and upper limits of parts based on certain criteria, I want to display the parts available between and including these numbers. The 13 available numbers are based on the strength of the part, so 35, 40, 63, 65, 80, 85, 100, 105 etc. If the cells show 63...

Is it possible to display a custom userform message at two different times on the same day using 1) one userfrom 2) not being available to close the earlier form ? The earlier userform time to display blocks the later userform display from displaying. What I want is to be able to show BOTH...

I have a numeric cell, that I would like to be able to enter "-123" and the cell displays "-1.23" or if the user enters "-1.23" the cell will display "-1.23" is this even possible? Thanks

Hi there, Im trying to display some tricky % number formatting and have hit a dead end. Just wondering if it's possible to display % under the following criteria Over 100%: +xxx% 0-100%: +xx.x% -100%-0%: [red]-xx.x% Under -100%:[red]-xxx% The key is basically to retain the +/-, the...

RE: Multiple display of timed userforms ... Action1: it's 8:00 AM. Open a new Userform1(blank textbox1): Enter data: Userform.DTPicker1.value = Time 10:00 AM (display time) Userform1.Textbox1.value = Buy oranges close userform Action2: 5 minutes later: open a new Userform1(blank...

Hi All, This may be easy for some but I have looked around and can't see an answer to my issue. I have created a form with a number of checkboxes and when I pull the data from access into excel in a table format all the details from the check boxes show ether False or True. Is there anyway...

Hello, I’m trying to display the latest value entered on adifferent tab (pretty much a Vlookup example). In the column on “Tab_2” an employee enters the new amountof mileage driven in the rented car once it’s returned (see example below. Date and Mileage are two different columns)...

Hi, I have a spreadsheet with 5000 rows and 15. The 1st Column either has a Y or N in it and the 12 column either has a 'South' or "West" in it. What I would like to do o a different sheet is display only the rows that have a Y in column 1 and South in column 12. I would also like to only...

Hello The below code somehow overwrites the formula typed in rangeE1 What i am trying to do is that if i check value as formula then the txtValue should display the Formula if unchecked then it should display the value in textbox this is like Formula Bar and Cell Value. Second thing if i type...

Could I ask for some help from you experts with a formula please. I am having an issue with trying to get the correct result for an investment portfolio that I am building. My isue is obtaining the correct RIO value in cell O27 for the month of July. Here are the cells that are being...

Hello OMG What i face now is when values displayed in formula bar as 200600 it displays as 200,600 in cell instead of 2,00,600 ie incorrect comma placement Following values 4,14,180 to display as 4,14,180 it displays as 4104,180 3,18,600 to display as 3,18,600 it dispalys as 3108,600 17676.40...