display

Alright, so I have looked everywhere online and cant even find a specific way to do what I need or even if there is a way to do it. So right now I am trying to create a list of dates that always displays the last 8 entries of dates in a data pool. So when I add a new date with values it will...

hi am finding it hard to explain it but it should be easy in the example <tbody> A B C D E F G 1 Score Level Score Level 2 10 AA 10 =????? 3 20 BB 15 AA 4 50 CC 18 AA 5 100 DD 25 BB 6 200 EE 70 CC 7 </tbody>

Hi I have a simple lookup: =IF(ISNA(VLOOKUP(B183,'Sheet2'!A:T,20,FALSE)),"",VLOOKUP(B183,'Sheet2'!A:T,20,FALSE)) However, the result (i.e. the data in Col T had 9 characters, but I need the lookup to only display the first 8 characters. Is there a way to do this? Thanks Paul

I've read a few posts but none that answer the question for how to not display the decimal point: Two scenarios: 100.3897364 and 102 should appear as: 100.39 and 102 but this format shows 100.39 and 102. (with the decimal). How do I keep the decimal from appearing when a whole number...

Hi everyone, I'm stumped. In my excel file, B2 will always have a date. If C2 and D2 may display a date, nothing at all or zeros. I want the correct date to display in E2. B2 always has a date. If C2 has a date that isn't 0, I want to use that one instead of B2. And if D2 has a date that...

I want to extract specific numbers after some specific words from textpad and I have to write that into my excel columns i.e example, the textpad file is like this *INFO* CRITERIA is MATCHED. DISPLAY ID 123456 AND AT T=369 MAY BE MATCHING OR MAY NOT BE *INFO* CRITERIA is...

If cell A1=2 then I want to subtract B2-B1 and if the number is a negative value, Display a blank cell. I'm a novice and can't figure how to do this. Thank you.

Hi All, I'm currently trying to get an IF function to work where i want the function to basically say, if the number is below -10000 or above 10000 then display "STRAIGHT" in the cell. If not then display the original cell value. I've tried =IF((BO31<'-10000,BO31>10000),"STRAIGHT",BO31) but it...

I have a userform with labels (Label1.Caption = Store-1 & Label2.Caption = Store-2) I want to display on the Chart Legend. I would like to the Chart legend to display the captions of each label. How can I accomplish this? i.e. Legend 1 = Label1.Caption Legend 2 = Label2.Caption Also, my...

Hello I have a master workbook template that many people use for a request form, as soon as they press SEND the origional form is kept on there local drive as a blank form. However the sent file is saved on a network location with its own unique workbook name, My question is that on the...

Hello, I'm using the following formula on B2 =ROUNDDOWN((TODAY()-DATE(E2;C2;D2))/365,25;1 to display the current ages of a list of people on column A. E2 is the 2-digit year, and recently some people born in the 2000s have been added to the list, making my life difficult. If I type 2000 the...

Hi i have a pivot table that i need to construct which has a mixture of words and numbers. Under the "Values" section of the pivot table, i have 8 columns of data, 2 of which i need to be shown as texts such as "New" or "Renovation". For the columns which i have numbers for: I can only seem...

I have a table on one sheet called BOOKINGS that has information for who booked a room, what room they booked, the date and what resources they need. I can look up and display every entry for a particular room easily enough but what I'd like to do is to display only the entries for that room...

Hi Setting up a document where I need to put in the total budget that each client had. Many will be, say, in the ilk of £120,000 whilst others might be £38.4m - is there a way to ensure that when the numbers are entered: £120,500 would be displayed as £120.5k £38,400,000 would display as...

I'm trying to make an IF formula to detect if there's any asterisks in the worksheet. =IF(WORKSHEET RANGE," * DOES NOT MEET SPECIFICATIONS ","") That way if there is one it will display *DOES NOT MEET SPECIFICATIONS" and if there isn't one it displays nothing.

Hello all, I would like someone to try and make me a macro that can display a couple of rows and columns based on a searched variable. I added a link to an example of a part of the excel document that I am working in. (It is a Google Spreadsheet) For example, I want to display row 26 up to...

Hi all, I’m working on a simple sheet where I have a few columns. The important ones are: A = first name B = surname F = points On another sheet within the same workbook I am trying to get it to display any person who has 3 or more points. I want it to display first name, surname and points if...

Excel 2010 & 2016: I would like to open a selected workbook and see it on screen to be worked with. At present it only loads in the taskbar. Is there way to code this or do I use Sendkeys to make it 'active'?

I would like to have a cell display the text "Process" if all of the cells in a range contains the word "Yes". Any of the cells in that same range contain the text "No" then have the cell display the text "Stop". And finally if any of the cells in a range contain "select one", the have the cell...

Good afternoon, Assuming I have the following items in a selected range: 1,2,2,2,3,4,4,5,6,6,7,7,8,8,9 can anyone suggest a VBA solution to display the number of items that occur in the list only ONCE? In the above example, the answer would be 4 as only four numbers occur uniquely in the list...