Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 175748 times)

Offline Yammer

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2015
  • Posts: 3697
  • Total likes: 215
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #740 on: December 28, 2016, 05:11:36 PM »
IDK what :00-45:00 means.

If you mean negative time, i.e. negative 45 minutes:
  • Negative 45 seconds is -0.03
  • Excel doesn't default to allowing negative date-time, you have to follow the instructions here.
  • Format to whatever time format you like.
Sorry i wasn't being clear.

I want to edit a video from :04-:18 ( 4 seconds until 18 seconds.) The entire video length is currently 45 min.

Offline lubaby

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2010
  • Posts: 5230
  • Total likes: 629
  • DansDeals.com Hat Tips 12
    • View Profile
Re: Excel Problem
« Reply #741 on: December 28, 2016, 05:20:19 PM »
Sorry i wasn't being clear.

I want to edit a video from :04-:18 ( 4 seconds until 18 seconds.) The entire video length is currently 45 min.
Editing the video in Excel?

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12208
  • Total likes: 2212
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #742 on: December 28, 2016, 05:25:59 PM »
Sorry i wasn't being clear.

I want to edit a video from :04-:18 ( 4 seconds until 18 seconds.) The entire video length is currently 45 min.
What are you looking to type in the cell?
Workflowy. You won't know what you're missing until you try it.

Offline CZ60

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jul 2014
  • Posts: 431
  • Total likes: 38
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: New York
Re: Excel Problem
« Reply #743 on: December 28, 2016, 06:11:59 PM »
Editing the video in Excel?


What are you looking to type in the cell?

At least I'm not the only one confused :o

Offline Yammer

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2015
  • Posts: 3697
  • Total likes: 215
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #744 on: December 28, 2016, 09:26:59 PM »
Editing the video in Excel?

What are you looking to type in the cell?

At least I'm not the only one confused :o
OK OK.....Let's start over...

I have a video that requires editing. I'm writing down the places that need to be cut. So I took an excel sheet to jot down the places that I will keep. For example:
:04-:18 ( from 4 seconds to 18 seconds )

I tried to write each edit into a cell and send it to the editor. But when I changed the column format to time it changed the timing based on the hour or date. All I need are minutes and seconds ( that don't change into times. )

Online aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 13369
  • Total likes: 8171
  • DansDeals.com Hat Tips 13
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Problem
« Reply #745 on: December 28, 2016, 09:29:31 PM »
OK OK.....Let's start over...

I have a video that requires editing. I'm writing down the places that need to be cut. So I took an excel sheet to jot down the places that I will keep. For example:
:04-:18 ( from 4 seconds to 18 seconds )

I tried to write each edit into a cell and send it to the editor. But when I changed the column format to time it changed the timing based on the hour or date. All I need are minutes and seconds ( that don't change into times. )

Formatting as text before you enter anything will keep it as entered.
Feelings don't care about your facts

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12208
  • Total likes: 2212
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #746 on: December 28, 2016, 11:03:26 PM »
OK OK.....Let's start over...

I have a video that requires editing. I'm writing down the places that need to be cut. So I took an excel sheet to jot down the places that I will keep. For example:
:04-:18 ( from 4 seconds to 18 seconds )

I tried to write each edit into a cell and send it to the editor. But when I changed the column format to time it changed the timing based on the hour or date. All I need are minutes and seconds ( that don't change into times. )
I just tried a few different things and all of them stayed exactly how I typed them:
Workflowy. You won't know what you're missing until you try it.

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2982
  • Total likes: 111
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #747 on: January 02, 2017, 02:01:04 PM »
I'm looking too make a chart/graph of all expenses from last year, split into categories. When I try to insert graph, it says maximum 255 entries. Any other way to achieve the same results?

Offline lubaby

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2010
  • Posts: 5230
  • Total likes: 629
  • DansDeals.com Hat Tips 12
    • View Profile
Re: Excel Problem
« Reply #748 on: January 02, 2017, 02:02:45 PM »
I'm looking too make a chart/graph of all expenses from last year, split into categories. When I try to insert graph, it says maximum 255 entries. Any other way to achieve the same results?
Pivot table will give you all the totals (by category), that can be turned into a graph.

Offline yesitsme

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2014
  • Posts: 4118
  • Total likes: 1514
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #749 on: January 03, 2017, 09:45:58 PM »
.
["-"]

Offline shulem92

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2015
  • Posts: 2982
  • Total likes: 111
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #750 on: January 03, 2017, 10:33:20 PM »
Pivot table will give you all the totals (by category), that can be turned into a graph.
Thanx. It worked

Offline talmid chuchem

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2014
  • Posts: 1035
  • Total likes: 50
  • DansDeals.com Hat Tips 5
    • View Profile
Re: Excel Problem
« Reply #751 on: January 05, 2017, 10:42:56 AM »


.
AccelerateyourVBscript

What's this for

Offline lubaby

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2010
  • Posts: 5230
  • Total likes: 629
  • DansDeals.com Hat Tips 12
    • View Profile
Re: Excel Problem
« Reply #752 on: January 05, 2017, 12:44:12 PM »

What's this for
Seems like it can teach you (or do for you) some basic* Excel functions.

*Using this term very liberally.
« Last Edit: January 05, 2017, 12:49:37 PM by lubaby »

Offline lechatchileh ariber

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Mar 2013
  • Posts: 895
  • Total likes: 24
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #753 on: January 12, 2017, 12:50:58 AM »
Anyone have experience with the following; I'm on a mobile device and want to use a data entry form. I can't find an app that will let me insert a form in their sheets (I tried Google forms syncing to a sheet but didn't work too well).
If I make the document on a computer will it work on a mobile?
I don't sin, I give myself opportunities to repent.

Offline Work-for-ur-muny

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2014
  • Posts: 3101
  • Total likes: 318
  • DansDeals.com Hat Tips 34
    • View Profile
Re: Excel Problem
« Reply #754 on: January 23, 2017, 04:37:33 PM »
I want to color format a cell based on a letter that I have in a different cell. Is there any way to accomplish that?

Example: Column A has customer names and and in column B I enter y if they payed, and n if they didn't. I want the cell right near it on column C to turn red if they the adjacent cell in column B has an n. (No need for anything if there's a y.)

Offline stooges44

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jan 2017
  • Posts: 6038
  • Total likes: 1905
  • DansDeals.com Hat Tips 262
    • View Profile
Re: Excel Problem
« Reply #755 on: January 23, 2017, 04:59:33 PM »
I want to color format a cell based on a letter that I have in a different cell. Is there any way to accomplish that?

Example: Column A has customer names and and in column B I enter y if they payed, and n if they didn't. I want the cell right near it on column C to turn red if they the adjacent cell in column B has an n. (No need for anything if there's a y.)

Would it help if you colored the cells in column B instead? Meaning, color all the n cells red?
If it's not free shipping it's not worth it.

Offline Work-for-ur-muny

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2014
  • Posts: 3101
  • Total likes: 318
  • DansDeals.com Hat Tips 34
    • View Profile
Re: Excel Problem
« Reply #756 on: January 23, 2017, 05:00:36 PM »
Would it help if you colored the cells in column B instead? Meaning, color all the n cells red?
I need it to be in an adjacent cell.

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12208
  • Total likes: 2212
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #757 on: January 23, 2017, 05:10:05 PM »
I want to color format a cell based on a letter that I have in a different cell. Is there any way to accomplish that?

Example: Column A has customer names and and in column B I enter y if they payed, and n if they didn't. I want the cell right near it on column C to turn red if they the adjacent cell in column B has an n. (No need for anything if there's a y.)
Sure! Set up Conditional Formatting and "use a formula  to determine which cells to format".
Workflowy. You won't know what you're missing until you try it.

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12208
  • Total likes: 2212
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #758 on: January 23, 2017, 05:12:22 PM »
This example colors the cell in column C blue, if column A is "1".

Select Column C and create this rule:


Results:
Workflowy. You won't know what you're missing until you try it.

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3379
  • Total likes: 555
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Problem
« Reply #759 on: January 23, 2017, 05:12:40 PM »
I need it to be in an adjacent cell.
Conditional formatting:
  • Highlight the cells in C that you want to change color. In the Home ribbon, select Conditional Formatting > New Rule > Use a formula to determine which cells to format.
  • Click into the formula bar below and type =B2="Y" (assuming B2 is the first cell with y/n values, if not adjust it to whichever cell is).
  • Click Format > Fill (along the top) > and select green as the background color.
You can then reselect the cells in column C and color them red. This will give them a default of red, only turning green when you mark "y". Alternatively, you could repeat the steps above, replacing Y with N and green with red. This will give a default of no color, green for Y and red for N.