excel question

  1. M

    Columns- count a consecutive series of positive or negative numbers and then get a sum of the max frequency

    Columns- count a consecutive series of positive or negative numbers and then get a sum of the max frequency Example: <tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;"> A B C D E F G H I...
  2. D

    VBA to track History changes from a worksheet to a new worksheet

    Hello I need help and not able to find my solution. I have in a sheet called TOC on cell J33, which updates every 2 minutes based on a = function to another sheet that uses a api query. My goal is to track last value (history) before it updates, and have the data output on another sheet...
  3. H

    Need help on Leave Planner template formula

    Hi there, I'm creating a new leave planner for my team and I have followed one template and created half of the it and now struck up use the dashboard formula which can update the data by referring the data sources. I would need help on using the below formula...
  4. W

    Year-to-Date (YTD) Formula Help

    Can anyone please help me figure out a formula to calculate YTD?? What I am trying to achieve: Sum all months <= current month, ONLY IF months fall within the same year CY (Calendar Year) as the current month As you can see on the screenshot below, Cell B5 indicates the current month. The...
  5. D

    Tricky one

    <colgroup><col><col></colgroup><tbody> Array 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H 9 I </tbody> <colgroup><col><col></colgroup><tbody> Lookup Value Apply Vlookup only Daiwik1 Daiwik1 value should be "A" and like wise...
  6. Y

    need help with designing an excel macro!

    I have two reports with 10 and 10 columns each. I need to copy data from "A,C,E and F" and "A,C,D, and F" columns respectively from Sheet 1 and Sheet 2 to be entered to another report to find out mismatch. How should I do this?
  7. E

    Create a dynamic rolling trailing 7-day average that auto updates

    I am creating a dashboard and I want it to automatically create a 7-day trailing average based off the the =today() cell that it looks up on. So I have the raw data in a sheet that has the data by day: <tbody> 8/1/2015 8/2/2015 8/3/2015 8/4/2015 8/5/2015 8/6/2015 8/7/2015 8/8/2015 People...
  8. D

    Vlookup qustion.

    Hi, I need a little help and I hope I can explain this correctly. I have a document with multiple sheets. (sheet1, sheet2, sheet3). There are hundreds of thousands of business names in one column on the first sheet. we will say (sheet1!A) I need to compare the name of the business to the...
  9. A

    Copy and Cut Disabled

    Hello everyone I'm sort of new to excel VBA and new to this forum, and I was wondering if someone could help. I recently copied and pasted a macro, specifically the one in this link VBA Express : Excel - Disable Cut, Copy, Paste. It disabled copy, cut, and paste on the particular workbook, but...
  10. C

    Macro Help Required for Multiple Column to Single Column Conversion (With Header Info)

    Dear Experts, I intend to re-arrange the data generated by system. I am using Office 2010 Current Format: Mat No Cost1 Cost2 Cost3 A 5 3 2 B 6 9 3 C 7 6 2 To be Format: Mat No A 5...
  11. F

    I need help in formula,,,

    DATE BALL # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 10/29/2013 8 8 10/29/2013 3 3 10/29/2013 12 12 10/29/2013 7 7 I made a small sample made hand (number color) I...
  12. F

    Question on Count

    Is there any way (like countifs function) to count number of blanks in a column provided a number is present in the previous column, Ex. In the ninth row, the data for 2011 is blank but the previous column some data is present, is there any way I can count such instances using a fuction...
  13. D

    Using frequency formula to find number of unique text occurrences

    Hi All, Had to know if the frequency array function can be applied for a text which we can by using the following formula "=SUM(IF(FREQUENCY(IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""), IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""))>0,1))" which gives the unique occurrences of text in column A...
  14. D

    Counting how in how many days an item appears, when some items may appear more than once in a day

    M2222 12/07/12 M2230 12/07/12 M1087 12/06/12 M2525 12/05/12 M2525 12/05/12 M8899 12/05/12 Above is an example of what I am working with. I am trying to get a count of how many times the values on the left appear. But in some cases those values occur more than once in a single day. If they occur...
  15. B

    Toggle buttons display problem - Excel 2007

    I have an Excel xlsm file that uses several toggle buttons to show/hide columns. These toggle buttons are perfectly aligned on every user screen I have looked at with one exception. On the one user's PC, the toggle buttons are misaligned and are even different sizes. They still function and...
  16. V

    If Match Function

    Hi, I want a formula smiler below. =IF(MATCH(B2,D2:D20,0),"MATCH","NOT MATCHED" But when i use it, it gives false value with '#n/a' . pls help in this.
  17. B

    Two Vlookup and provide total of given account number

    Data <TBODY> 10/01/12</SPAN> 2000</SPAN> 3000</SPAN> 4000</SPAN> 5000</SPAN> 6000</SPAN> 1A</SPAN> 1.00 </SPAN> 2A</SPAN> 2.00 </SPAN> 3A</SPAN> 3.00 </SPAN> 4A</SPAN> 4.00 </SPAN> 5A</SPAN> 5.00...
  18. V

    Excel Formula required (text)

    Hi All, I want help to get a formula in excel. I have a list of mobile no.s and next column of this it's Gift. I want formula that when a mobile repeat or select more than 1 gift then formula merge it separate via "," in next column Data is like below. <table border="0" cellpadding="0"...
  19. R

    How to find unhide column numbers in Active Sheet

    I have an active sheet where any of the columns maybe hidden, but I don't know what columns are hidden. How to search the columns which are hidden in the active sheet using VBA. Also I want to unhide the columns whichever hidden, at the same time i want to store the no of columns which are...
  20. Y

    Code to open file

    Hi Everyone, the below could does direct me to the file, but when I click on the file, it does not open it? any ideas? Option Explicit Sub GetImportFileName() Dim Filt As String Dim FilterIndex As Integer Dim FileName As Variant Dim Title As String ' Set up list of...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top