species

  1. M

    Power Pivot measure dividing two other measures not working, please help.

    Hello and thank you in advance if you can help, I am using excel 2019 on a desktop, not Power Bi. I had posted this in the Power Bi section of this forum, but I think now, because I am not using power Bi but Power Pivot in excel 2019, I should have posted it here. I am trying to create a...
  2. M

    Can't get new measure based off other measures in Power pivot to work, please help.

    Hello and thank you in advance if you can help, I am using excel 2019 on a desktop, not Power Bi. I am trying to create a measure in power pivot that, despite repeated attempts, is not working. I have, in other scenarios, divided one measure by another to get a % I needed (or the decimal), but...
  3. M

    Can a Measure create more than one value?

    Hello and thank you in advance if you can help, I am VERY new to using measures. I am using Excel 2019 on a PC. I have created some measures that will give me a distinct count of species in a query/dataset, as well as a distinct count of blocks. My data has fields/columns for All Regions...
  4. R

    Find rows/groups with unique values and return

    I am having 127 columns and 405 rows. A row consist of a group and column has individual (value of the cell consist of = "Unique accession | individual name or Species") as given below. <tbody> Groups Individuals (Unique accession | individual name or Species) Group[ 0 ]...
  5. D

    Autopopulate cells based on a list in another worksheet

    Hi all, First time poster, long time user. Could somebody please help me with a macro that I would be far out of my depth with, and would help me save a plenty of writing long words in the future. I deal with a lot of plant samples from day to day and about 10,0000 need to be entered over the...
  6. M

    Index/Match and return value when date falls within a range..Please Help!

    Thank you in advance if you can help. I started a new thread because I couldn’t edit my previous thread and I wanted to refine my request better. I found an old post here on the forum that is very much like my issue...
  7. M

    VBA/Advanced Filter with parameters...any advice appreciated!

    Hello, and thank you in advance for taking the time to look over this request. I am working on a PC in excel 2013, and I have a large data set/sets that I need to flag (or produce in a separate sheet) data that does not fit into several categories. I have a list of bird species with observation...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top