displays

I have a chart which includes a data table but some of the columns have disappeared. This is really weird as you can see from the data table its referencing the data but not displaying in the chart itself. The data ranges from value 0 to 5 and the chart displays the columns for the first 24...

Hey guys quick question could not seem to find online. I have variable letters for example BN and would like a formula that would subtract that value by one so it displays BM. Any suggestions would be much appreciative.:):)

Hello everyone, I made a Macro and it uses many user forms depending on the buttons you clic. The point is that I use a .vbs script to run it without having to open the excel workbook. It displays the login userform and everything works perfectly. The problem is that after you are done using...

hi, Any one have the formula so if a cell > 0, then that cell -30 but if that cell is empty dont display anything? I know if I used =if(a1>0,a1,"") that works, but when I add the -30 it either displays -30 or #value can someone sort me out? KR Trevor3007

I have two sets of IP addresses in my pivot table How can I make the pivot table show all rows of data How it displays at this time is the 1st line of data then a blank row below it.

Hello, I have some formulas in some cells that display 0. When I SUM these cells it displays 1241. Also, in some other instance, the sum is VALUE when I only see numbers in these cells. Can you tell me please what the problem is?

Hi, I have the following formula =IFERROR(INDEX(Data!$D$2:$D$100, SMALL(IF($A$2=Data!$C$2:$C$50, ROW(Data!$C$2:$C$50)-ROW($A$2)+1), ROW(1:1))),"" ) Which indexes the D column in Data tab and then performs a Small Array on the C column of Data which then displays the corresponding data from...

Hi there I have the existing formula =COUNTA(AL23:AL169)/COUNTBLANK(AL23:AL169) which displays the result 93% I want to change it so it counts the blanks cells AND those cells which are 0 or "-" then displays that total number of cells as a percentage of overall number of cells, i.e. the 93%...

I'm trying to have a textbox default value work similar to a formula. I'm using Me.TextBox2.Value = And I want the value to be ws1.Range(C4) + 1, and if that is >4, then I want the value to be 1. (C4 displays the current quarter, and I want the texbox to default to the next sequential...

Hi, I'm creating a cash-up sheet for a bar, and I'm keen for various phone-usability related elements. I've found excel on phones handles drop downs far more smoothly than raising up the keyboard after double tapping a cell, so zoomed out so you can see other cells but not so zoomed out you...

I have a formula "=sheet1!C2" excel displays 9/10/18. When I update th formula to be "=sheet1!C2 & " - " &Sheet1!D2", EXCEL displays 43353 - 43357; I want it to display 9/10/18 - 9/17/18. What do I need to add to the formula. Thanks!

I have designed a dashboard for work, one of the sheets (called calculations) contains all of the raw figures and the other sheet I use displays the dashboard. I have the dashboard automatically change the chart depending on the month / specific figure selected (see below). In the above...

Hello there!! Pleased to seek any help in fixing my pivot function difficulty. I want my data be sorted in one row and different column but when I am doing the pivot it displays one column and different rows. TIA for the help it mean alot

I created a pivot that that has a "YYYY-MM" column (2018-01). My source data displays the date using the custom format of YYYY-MM and displays as 2018-01. When I create my pivot, the date displays as "Jan", "Feb", etc even though I have multiple years in my source data. I have tried to format...

MS Excel 2007. I have an address data base in which Column J contains Zipcode in 6 digits. I have this Column J formatted under category "Text". For convenience I have entered only last 3 digits, for example 096 in J2. My requirement: A formula for Column J. J2 displays 096. I want this to...

Hi Everyone I am running an event macro from sheet A and I want to display sheet B on the screen before a message box displays. However the message box always displays first and Sheet B displays after I click OK. I have tried Doevents, application.screenupdating = true, sheet.activate etc but...

Hi! My task is: I have an Excel sheet with a hundred hyperlinks pointing to files on a webserver that need to be retrieved with parameters (e.g. http://mytestserver:8080/Pictures/Image.aspx?id=f924d786-c9ec-4fc5-af53-dd3964f826ca&format=jpg) Running the above mentioned link opens the file in...

Thank you for your time first and for most. I have Sheet 1&2. I want cell A1 in Sheet 2 referencing cell A1 in Sheet 1, whatever appeared in Sheet 1 cell A1 needs to be in cell A1 Sheet 2. This part is done. the next part is when cell A1 Sheet 1 has nothing, right now I want cell A1 in Sheet...

...if I change the last zero to "" for example. =IF($AS$2="No","",ROUND($AI2*VLOOKUP($AJ$2,_ParameterTable,19,FALSE),0)) Works perfect if the initial IF is false; it displays a BLANK. But I can't edit the last zero so that an error or problem in the formula displays a BLANK as well. Let me...

I am using vlookup to populate cells in one column of my sheet, but when I have no value in the C column to draw from, the B column displays "#N/A". How can I modify this line to show an empty cell until I have input my value into the C column? =VLOOKUP(C2,'Sheet2'!$A$1:$B$2662,2,0)