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 126775 times)

Offline stooges44

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jan 2017
  • Posts: 5708
  • Total likes: 1332
  • DansDeals.com Hat Tips 260
    • View Profile
Re: Excel Problem
« Reply #990 on: June 19, 2017, 12:16:45 PM »
If it's not free shipping it's not worth it.

Offline lubaby

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jun 2010
  • Posts: 4800
  • Total likes: 350
  • DansDeals.com Hat Tips 12
    • View Profile
Re: Excel Problem
« Reply #991 on: June 19, 2017, 12:18:49 PM »
Does anyone know a formula to reverse the order of text within a cell?

EG: the text TCRVO is אברהם in hebrew but I have it written in excel as OVRCT so is there any way to reverse the order?

TIA

If you wanna do it on the Formula level, I found this online:

Code: [Select]
=IF(LEN(A1)<1,"",MID(A1,LEN(A1),1))&IF(LEN(A1)<2,"",MID(A1,LEN(A1)-1,1))&IF(LEN(A1)<3,"",MID(A1,LEN(A1)-2,1))&IF(LEN(A1)<4,"",MID(A1,LEN(A1)-3,1))&IF(LEN(A1)<5,"",MID(A1,LEN(A1)-4,1))&IF(LEN(A1)<6,"",MID(A1,LEN(A1)-5,1))&IF(LEN(A1)<7,"",MID(A1,LEN(A1)-6,1))&IF(LEN(A1)<8,"",MID(A1,LEN(A1)-7,1))&IF(LEN(A1)<9,"",MID(A1,LEN(A1)-8,1))&IF(LEN(A1)<10,"",MID(A1,LEN(A1)-9,1))&IF(LEN(A1)<11,"",MID(A1,LEN(A1)-10,1))&IF(LEN(A1)<12,"",MID(A1,LEN(A1)-11,1))&IF(LEN(A1)<13,"",MID(A1,LEN(A1)-12,1))&IF(LEN(A1)<14,"",MID(A1,LEN(A1)-13,1))&IF(LEN(A1)<15,"",MID(A1,LEN(A1)-14,1))&IF(LEN(A1)<16,"",MID(A1,LEN(A1)-15,1))&IF(LEN(A1)<17,"",MID(A1,LEN(A1)-16,1))&IF(LEN(A1)<18,"",MID(A1,LEN(A1)-17,1))&IF(LEN(A1)<19,"",MID(A1,LEN(A1)-18,1))&IF(LEN(A1)<20,"",MID(A1,LEN(A1)-19,1))&IF(LEN(A1)<21,"",MID(A1,LEN(A1)-20,1))&IF(LEN(A1)<22,"",MID(A1,LEN(A1)-21,1))&IF(LEN(A1)<23,"",MID(A1,LEN(A1)-22,1))&IF(LEN(A1)<24,"",MID(A1,LEN(A1)-23,1))&IF(LEN(A1)<25,"",MID(A1,LEN(A1)-24,1))&IF(LEN(A1)<26,"",MID(A1,LEN(A1)-25,1))
This is only for 26 characters, if you need more you can extend the nested formula.
« Last Edit: June 19, 2017, 12:23:18 PM by lubaby »
Once the game is over, the king and the pawn go back in the same box.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11333
  • Total likes: 1363
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #992 on: June 19, 2017, 12:19:20 PM »
Workflowy. You won't know what you're missing until you try it.

Offline SPLP

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2011
  • Posts: 1702
  • Total likes: 6
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Problem
« Reply #993 on: June 20, 2017, 12:46:11 PM »
Have excel on laptop and I save my doc's to laptop and Dropbox

some excel doc's on Dropbox do not open -and yet  other excel docs open as xlsk

this what i see when can not open a spread sheet
 
                             original xlsk
                   Office Open XML spreadsheet

how can I open?
« Last Edit: June 20, 2017, 12:49:32 PM by SPLP »

Offline SPLP

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jun 2011
  • Posts: 1702
  • Total likes: 6
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Problem
« Reply #994 on: June 21, 2017, 02:28:07 AM »
sorry to bump so soon--but-- need the info on my I-pad and this is the only device I have with me

Offline Yammer

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2015
  • Posts: 3662
  • Total likes: 213
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #995 on: June 30, 2017, 11:10:52 AM »
I would like to move every second row to column B and every 3rd row to column C.

Anyway to do do it ?

Online skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3084
  • Total likes: 235
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Problem
« Reply #996 on: June 30, 2017, 11:16:41 AM »
I would like to move every second row to column B and every 3rd row to column C.

Anyway to do do it ?
This is what I usually do. Set B1 =A2, C1 = A3 and D1 =1, and E1 =MOD(D1-1,3)=0. Copy that all the way down to the bottom of the list. Then select the whole group of value and copy/paste values. Now sort by column E and delete all the FALSE rows.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7247
  • Total likes: 283
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #997 on: June 30, 2017, 03:11:58 PM »
So I added fancy clickable (non macro) buttons to a a couple of thousand rows... Now it's all too slow. how do I get rid of em all?

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7247
  • Total likes: 283
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #998 on: June 30, 2017, 03:14:06 PM »
I would like to move every second row to column B and every 3rd row to column C.

Anyway to do do it ?
Just do it manually in two rows as = then drag down the pattern

Offline bermo

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Feb 2014
  • Posts: 1539
  • Total likes: 17
  • DansDeals.com Hat Tips 11
    • View Profile
Re: Excel Problem
« Reply #999 on: July 19, 2017, 06:20:44 PM »
i am trying to add up hours using =TEXT(G27-F27, "h")
is it possible to add a few times slot like 8-10 AM 2-4PM it gives me a error when i try
=TEXT(G27-F27,I27-H27, "h")or things similar
TIA

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11333
  • Total likes: 1363
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #1000 on: July 19, 2017, 06:24:09 PM »
i am trying to add up hours using =TEXT(G27-F27, "h")
is it possible to add a few times slot like 8-10 AM 2-4PM it gives me a error when i try
=TEXT(G27-F27,I27-H27, "h")or things similar
TIA
How about
Code: [Select]
=TEXT(G27-F27, "h")+TEXT(I27-H27, "h")
Workflowy. You won't know what you're missing until you try it.

Offline bermo

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Feb 2014
  • Posts: 1539
  • Total likes: 17
  • DansDeals.com Hat Tips 11
    • View Profile
Re: Excel Problem
« Reply #1001 on: July 19, 2017, 06:39:28 PM »
How about
Code: [Select]
=TEXT(G27-F27, "h")+TEXT(I27-H27, "h")
Thanks that was simple.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11333
  • Total likes: 1363
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #1002 on: July 19, 2017, 06:46:01 PM »
Thanks that was simple.
my pleasure
Workflowy. You won't know what you're missing until you try it.

Online skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3084
  • Total likes: 235
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Problem
« Reply #1003 on: July 19, 2017, 07:54:34 PM »
How about
Code: [Select]
=TEXT(G27-F27, "h")+TEXT(I27-H27, "h")

No need to double up the formula (I assume, haven't tested yet):

Code: [Select]
=TEXT(G27-F27+I27-H27, "h")

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11333
  • Total likes: 1363
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #1004 on: July 19, 2017, 08:07:02 PM »
No need to double up the formula (I assume, haven't tested yet):

Code: [Select]
=TEXT(G27-F27+I27-H27, "h")
good point
Workflowy. You won't know what you're missing until you try it.