excel question

  1. K

    #How To make Hyperlink >Workbook File > Sheet 1 (Particular sheet link)

    How To make Hyperlink >Workbook File > Sheet 1 (Particular sheet link) # i try excel file create other excel file to particular sheet hyperlink making...... Pleased help me
    • krunal123
    • Thread
    • #excel tips #powerquery chart deskboard excel excel & formula excel & ilogic excel export excel question excel topics pivottable vba
    • Replies: 2
    • Forum: Excel Questions
  2. K

    How to Pull data One file to both file ????

    How to Pull data One file to both file ???? I try to Pull data "Master" File To "Local" & "Export" File .......... I don't Know ???? How to possible .......Pleased send us Formula in excel..
    • krunal123
    • Thread
    • easy excel tricks excel excel query excel question excel tricks pivotable vba
    • Replies: 1
    • Forum: Excel Questions
  3. K

    # How to Extend range in pivot tables ?? ?

    I was try refresh but not show data in pivot table, how to update data ...???
    • krunal123
    • Thread
    • #database #pivottable#vba #excel #excel #formula #confused #pivot table #power query excel question
    • Replies: 1
    • Forum: Excel Questions
  4. K

    HOW TO MARGE 3 TABLE IN ONE TABLE

    How to marge 3 table into one table , because i face reference error , i tried......, pleased solving this query.... step by step.
    • krunal123
    • Thread
    • #excel query excel excel & array excel error excel export excel question pivot pivottable powerquery
    • Replies: 3
    • Forum: Excel Questions
  5. K

    How Hide Row According value is Zero on Pivot tables ???

    How Hide Row According value is Zero on Pivot tables ??? Condition is zero value to hide table Entry in pivot tables.
    • krunal123
    • Thread
    • #excel #pivot #pivot tables #tables easy excel excel excel & formula excel query excel question excel tricks power query
    • Replies: 0
    • Forum: Excel Questions
  6. K

    How to sum with unique Invoice Number wise ?????

    # How to sum with unique Invoice Number wise ????? - Pleased Solve this query for formula ......very usefully trick for sale bill fill. like single invoice & two or more products in this sheet... problem is how to sum product based on unique Invoice No. - Pleased Help !!!
    • krunal123
    • Thread
    • excel excel & formula excel & ilogic excel formula excel queries excel query excel question vba
    • Replies: 6
    • Forum: Excel Questions
  7. K

    Query: How to count same party with unique Invoice numbers....

    like ... "SR FOODS LTD" two time make Purchase products. 1) how to count target Unique Invoice Number & same party Name ???????????????????????????????????????????????
    • krunal123
    • Thread
    • count with condititon excel & array excel formula excel query excel question excel tips excelexpert sale report
    • Replies: 1
    • Forum: Excel Questions
  8. 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...
    • mr_king
    • Thread
    • excel & formula excel & vba excel question help excel formula vba & excel 2016
    • Replies: 6
    • Forum: Excel Questions
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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?
  14. 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...
  15. 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...
  16. 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...
  17. 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...
    • charpotro
    • Thread
    • excel macro vb coding excel question macro help vb help
    • Replies: 5
    • Forum: Excel Questions
  18. 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...
  19. 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...
  20. 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...
    • Divakar
    • Thread
    • array formulas excel formulas excel question frequency function
    • Replies: 3
    • Forum: Excel Questions

Watch MrExcel Video

Learn Excel - Pivot From Many Sheets: Podcast #1331

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top