SOLVED

How do I find Origin of an excel sheet?

Occasional Contributor

How do I find Origin of an excel sheet?

I am trying to answer this question>What is the most common origin? How many cases have that origin?

10 Replies

Re: How do I find Origin of an excel sheet?

Find out which data sources are used in a workbook data model
1. In Excel, click Power Pivot > Manage to open the Power Pivot window.
2. View the tabs in the Power Pivot window. Each tab contains a table in your model. ...
3. To view the origin of the table, click Table Properties.

Find out which data sources are used in a workbook data model

If you're working with data that's been added to an Excel data model, then sometimes, you may lose track of which tables and data sources were added to the data model.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Re: How do I find Origin of an excel sheet?

It would help if you provided more detailed information. If you want to know the most frequently occurring value in a series of text values, you can use something like this:

The formula that returns the most frequently occurring value is

=INDEX(A2:A20,MODE(MATCH(A2:A20,A2:A20,0)))

And the frequency of that value is

=COUNTIF(A2:A20,C2)

Re: How do I find Origin of an excel sheet?

@NikolinoDE I figured that one out. Thank you for your help.
Now I am trying to convert a column with hours to days, do you have a formula for that?

Re: How do I find Origin of an excel sheet?

I don't know exactly what you want / need and what you want to calculate,

but I am still sending you this file with the time calculation.

If that is not exactly what you want, please explain again in detail

(on the basis of a file, without sensitive data, would be best)

and I will try to help you as far as I can.

Thank you for your understanding and patience

Nikolino

I know I don't know anything (Socrates)

Re: How do I find Origin of an excel sheet?

sry now i see your question

here is a examble hours to days with formulas

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Re: How do I find Origin of an excel sheet?

@Hans Vogelaar what is the formula to convert an entire column that is in hours to days?

Re: How do I find Origin of an excel sheet?

I apologize, I am very novice to Excel. If I have Column b1:b166, how do I add that to the formula's below?
=INT(C2/24*60) & " Days " & MOD(C2/24*60,1)*24 & " hours"
or
=INT(C2)&" days "&TEXT(C2-INT(C2),"h:mm")&" hrs. "
best response confirmed by allyreckerman (Microsoft)
Solution

Re: How do I find Origin of an excel sheet?

If B1 contains a umber of hours, for example 36, you can use

=B1/24

to return 1.5 as the number of days

Re: How do I find Origin of an excel sheet?

@@Hans Vogelaar and @@NikolinoDE Thank you both so much! Have great day!