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...

Watch MrExcel Video

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