show

  1. M

    Please help!! Need help with specialized formula.

    Hi everyone, Thank you in advance for your help! <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 142px"><col width="142"><col width="142"></colgroup><tbody> A B 1 10/24/19 =A1+10 2 #b7e1cd[/URL] , align...
  2. J

    Power Pivot/DAX: Problem with Like for Like Sales Figure

    I am trying to build a DAX measure in a Power Pivot to show the Like for Like sales figure (LFL). LFL is simply a measure to show the sales if the customer also had sales during the same period last year. I can not get any figures at all for this, and this is due to the previous year not...
  3. A

    Show results based on 3 Data Validation list

    Hi community, I have big table of monthly spending, i wanna know how can i show results based on Data Validation list choice, 1-List shows Models ( E:E ) 2-List shows Department ( B:B ) 3-List shows Month I need formula to return matching all 3 list, can anybody help me please?
  4. D

    IF/VLOOKUP formula question

    Hi all, Probably a really simple answer to my question. I've written the below formula to give me a tel number in a cell if one is held on another sheet and to show no tel held if it isn't there. The final part of the formula works fine but if i hold a tel number is gives me #value ! error...
  5. C

    Conditional Formula

    This would probably be a very simple question, but I can’tseem to get it right. What I need is a formula in a cell to say if this cell = a set of months i.e.January, April, July and so on then show this list of tasks and if the other monthsshow another set so example. =IF(C5=January,Feb,Mar)...
  6. J

    Edit chart category axis data items visible in VBA

    HI all, I have a workbook that crates a group of charts on a single worksheet. Each chart is based on 39 weeks' of data, but I want to show the last 8 weeks only, or be able to switch all the charts to show week 7, 15, 22 etc (it is school data, so weekly for now, but eventually the end of each...
  7. L

    VB colors name list

    Hi I have seen values like vbgreen, vbblue,vbred etc. Is there any list that show all VBColor list? like the list below but more colors. Thank you very much souce: https://excelabcd.co.in/2018/12/lesson123-how-to-change-cell-color-with-vba
  8. U

    Userform display control

    Using the following code to show/hide Labels and OptionButtons on a Userform UserForm1.Label5.Visible = False UserForm1.OptionButton2.Visible = False They still show, any ideas ?
  9. A

    Show Pivot Table data connection name

    Is there anyway to show the name of the data connection either in or outside the pivot table?
  10. JTL9161

    Sumproduct with an IF statement

    I have this formula below. I need to add and if statement to it that if the total is less than 4 (<4) then just put an 0 but if 4 or greater (>4) then show the number. =SUMPRODUCT(COUNTIF(R2:U2,B$192:Q$192)) Thank You, James
  11. H

    Increase / decrease arrows based on what user types in

    Hi. I have a RAID log and we wish to allow risk owners to indicate when a risk has increased or decreased in severity (in their opinion). So they would review each risk and for any that they felt had got better or worse, they'd be able to say "this one's getting worse", "this one's gotten...
  12. R

    Calculating time

    Hello, I have been racking my head on how to solve my time issue on my train sheet. I have a train time sheet to show if a train is on time or late Ex; if a train is set and ready to go at 01:30 and the crew is ordered at 03:30 i can show it to say 2:00 on time between these two times. but...
  13. D

    Count cell between dates by user

    Hello all, I have a tricky problem that I can't solve, and I would like help from more experienced people. I have a gantt chart to show the progress of tasks by user. Bar colors are made by conditional formatting, but each cell that is painted also has a value of "1" (while unpainted cells...
  14. H

    Pivot Table Sub Total

    Afternoon kind folks. I have a pivot table which I want to add a extra subtotal to. The pivot table shows a list of Business Reports in rows then the columns show the percentage complete by how well its done good/bad/not started etc. Currently I have to add an extra column on the worksheet...
  15. A

    Adding the date automatically when an input is inputted

    Without using Macros and VBA, is there a way for the date to automatically come out when a cell already has something inside it? For example: Let's say I want A2 to show today's date if some information is inputted in cell A1. =if(not(isblank(A1)),today(),"") will not work because it will...
  16. B

    Formulas displaying as text. Show Formulas NOT turned on. Fast fix for entire column?

    I've got a bunch of formulas displaying as text, instead of showing the value of the formula- "Show Formulas" is NOT turned on! I know the fix for a single cell is to click into the cell and hit the "Enter" key. is there a fix for an entire column, or range of cells? thx!
  17. G

    Screen Refresh

    On one worksheet I have a group of buttons (not actually grouped, but just adjacent). When I click one of the buttons is unhides another worksheet and hides the first worksheet. The buttons show as an image on the second worksheet and the real buttons on the second worksheet are not visible...
  18. D

    Charting Data

    I am trying to take data with random dates 9/5, 9/12, 9/19, 9/26 on the X axis and graph them and when I do the axis with the dates is reading all dates in between is there a way to only have the dates specified show up on the graph rather then all dates in between?
  19. M

    Chart Help

    Hello, I'm using excel 2016. Every time I try to do a bar chart, it comes up as thin lines going up and down. Modifying doesn't seem to help. Where are the bars? How can I get the lines to go away and show me the thick bars that I want? Thanks in advance.
  20. D

    Command button caption to show what is selected in the listbox.

    Hi, Please can someone help me? I would like my commandbutton1 caption to show what is selected in my listbox1. Any help would be appreciated. Thanks Dan

Some videos you may like

This Week's Hot Topics

Top