Logo
Picture

Excel Studio Works @XLStudioWorks

Creative and innovative Excel formula-based or complex VBA-based solutions for personal or business requirements. excelstudioworks.co.uk United Kingdom Joined July 2013
  • Tweets
    158
  • Followers
    742
  • Following
    279
  • Likes
    6
XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

10 years ago

@TrustATrader our tech team are creating a tool recovery system and would love your members feedback goo.gl/forms/l17fPJta… #losttools

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

10 years ago

@RatedPeople our technology team are creating a tool recovery system and would love your members feedback goo.gl/forms/l17fPJta… #losttools

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

@MrExcel simple,effective tip use CTRL+SHIFT+Down/Up etc to jump to the end of the section and highlight instantly.Good luck with your book

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

@XLStudioWorks: Useful #excel #vba Msgbox UBound(activeworkbook.userstatus) Show number of users currently in a shared workbook

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

#excel #vba to automate auto sizing of the rows where contents are larger than the current cell size: Rows("1:100").EntireRow.Autofit

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

#excel formulas - =TRIM(A1) in any cell will give you the value of cell A1 with any rogue trailing or leading spaces removed, #cleandata

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

#excel text data potential errors - look out in a list of data where rogue trailing or leading spaces were added in entry. Use TRIM(..)

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

#Excel over #access =match(1,index((A:A=C1)*(B:B=D1),0),0) Gives rownumber where a row contains 2 specific values in different columns

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

#excel formulas Force number to round up/down Cell A1 = 575 to become 500 =FLOOR(A1,100) Cell A1 = 525 to become 600 =CEILING(A1,100)

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

#dell #dellvenue8 still the only tablet for #excel VBA. Screen stuck on portrait. No help from Dell but Windows key + o will sort it.#atlast

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

Useful #excel formula Substitute multiples =substitute(substitute(substitute(TEXT,OLDTEXT,NEWTEXT),OLDTEXT2,NEWTEXT2),OLDTEXT3,NEWTEXT3)

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

#excel formulas Force number to round up/down Cell A1 = 575 to become 500 =FLOOR(A1,100) Cell A1 = 525 to become 600 =CEILING(A1,100)

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

@excelwriter #office365 no pivots either on the iPad!? Maybe just use the iPad to view. I wonder when we'll see full and real compatibility.

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

Upgraded to #office365 for collaboration mainly in #excel on PC and iPad. No VBA compatibility on the iPad as far as I can see!

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

@kumarapush @XLStudioWorks it gives the rownumber where the value in C1 appears in colA & value in D1 in colB on same row.

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

Useful #excel formula =match(1,index((A:A=C1)*(B:B=D1),0),0) Gives rownumber where a row contains 2 specific values in different columns

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

Useful #excel Sum the values in col A where date in col B is between 2 dates (G1 and H1) =sumifs(A:A,B:B,">="&G1,B:B,"<="&H1) #excelhelp

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

Useful #excel formula Substitute multiples =substitute(substitute(substitute(TEXT,OLDTEXT,NEWTEXT),OLDTEXT2,NEWTEXT2),OLDTEXT3,NEWTEXT3)

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

Hope @amyaccountant can help us with our business accounting.

XLStudioWorks Profile Picture

Excel Studio Works @XLStudioWorks

12 years ago

#excel userform #VBA #excelstruggles with UK format dates 'correcting' them to US Standard....even with UK settings. Apparently no solution

Trends for United States

Acuff
#NBADraft
Caleb Wilson
Ghana
Keaton Wagler
Darryn Peterson
Byram
Brayden Burries
Yaxel
AJ Dybantsa
Clippers
Mara
Kyle Davidson
Kingston Flemings
Morez
#WWENXT
Panama
England
Cam Boozer
Hawks

You might like

Excel website & blog by Debra Dalgleish @ddalgleish Excel MVP
Contextures
@contextures
5K Followers
ZohoDude offers expert Zoho development, consulting, and administration tailored to your business needs.
ZohoDude
@Zohodude_IT
682 Followers
Excel Prodigy - Advance level Excel Training center in Chennai, we conduct Microsoft Excel Training (corporate and individual).
Excel Prodigy
@excelprodigy
975 Followers