@Scrip_Tips profile picture
Scrip_Tips @Scrip_Tips

We aim to provide a platform for Fun & Business IT tips for creativity, productivity, automation and process improvements. #Excel #Hyperion #API interfacing.

Joined February 2015
  • Tweets 133
  • Following 29
  • Followers 23
61 Photos and videos
#Excel: If #VLookUp Column is Text then there is no need to format it as #. Prefix LookUp # with "" to get results.
1
Scrip_Tips@Scrip_Tips
15 Mar 2018
Hapi #Pi Day! Formatting using date functions in XL/BO, #Excel: TEXT(TODAY(),"m.dd") = 3.14 #BO: FormatDate(CurrentDate(); "M.dd") = 3.14
#Excel #Formula: Using the #Count and #Offset Functions, one can display the Nth Instance of a particular #Key in... fb.me/ViciJC7Q
#Excel #Formula: Using the #Count and #Offset Functions, one can display the Nth Instance of a particular #Key in the format of #Text or #Value occuring in a desired Column. Additionally this can aid in filter manipulation of duplicate values while working on combining #Datasets.
#Excel #VBA: Another variation to the last row formula. For Col B, Range("B" & Rows.Count).End(xlUp).Row... fb.me/6MPaNrpaR
#Excel #VBA: Another variation to the last row formula. For Col B, Range("B" & Rows.Count).End(xlUp).Row Previous: x.com/Scrip_Tips/status/8609…
Scrip_Tips@Scrip_Tips
6 May 2017
#Excel #VBA: An alterative to SpecialCells(xlCellTypeLastCell) for finding last row in a col, Range("A" & Range("A:A").Count).End(xlUp).Row
Scrip_Tips@Scrip_Tips
26 Aug 2017
#Excel #WEBI: A nice article on combining Spreadsheet and Universe data in SAP BO reporting using merged dimensions. blogs.sap.com/2015/09/23/how…

How to Merge BI Universe and Excel Data in Webi

Purpose of this document This document describes the how we can merge Universe and Excel datasource in webi and issue that could occur while doing merge. Also how to validate universe data based on...

community.sap.com
1
Scrip_Tips@Scrip_Tips
15 May 2017
#Excel #VBA: This one liner can help to quickly convert #s stored as text into #s better than GUI method. Selection.Value = Selection.Value
#Excel #VBA: An alterative to SpecialCells(xlCellTypeLastCell) for finding last row in a col, Range("A" & Range("A:A").Count).End(xlUp).Row
#Excel: A comparison of #String joining #Functions especially #TEXTJOIN which offers much more robust features... fb.me/7txZZvBms
#Excel: A comparison of #String joining #Functions especially #TEXTJOIN which offers much more robust features than #CONCAT or #CONCATENATE.
1
Scrip_Tips@Scrip_Tips
31 Jan 2017
#OneDrive: To access PC Files from any other Laptops, Tablets or Mobile Devices through the MS OneDrive Cloud... fb.me/87v8IbIYr
Scrip_Tips@Scrip_Tips
31 Jan 2017
#OneDrive: To access PC Files from any other Laptops, Tablets or Mobile Devices through the MS OneDrive Cloud enable the option shown below.
1
Scrip_Tips@Scrip_Tips
31 Aug 2016
#CMD: When uninstalling #UNIX #Emulator on #Windows, delete #unremovable files using the \\.\ or \\?\ path prefix Del \\.\C:\Cygwin\CON.cif
1
1
Scrip_Tips@Scrip_Tips
14 Aug 2016
#Excel: A #Financial % #Allocation method can be used to derive detailed obj (BUD) based on summary ref (ACT) #data.
1
#SharePoint: To migrate #Surveys from one site to another, save the #List as template under settings with "include contents" option checked.
Scrip_Tips@Scrip_Tips
28 Jun 2016
#PDF: To preserve textbox fields using the "Fill & Sign" option, make a copy of the final draft to add signature since reedits can't be done
Scrip_Tips@Scrip_Tips
14 Jun 2016
#Outlook: Ensure #Privacy on all #Calendar Items when others schedule #Meetings by setting read permissions to None.
Scrip_Tips@Scrip_Tips
26 May 2016
#Excel #VBA: Do loops are dynamic alternatives to For loops and gives options to check conditions at beginning (While) or ending (Until)
Scrip_Tips@Scrip_Tips
30 Apr 2016
#Essbase: When extracting data through #SmartView VBA API, if the members aren't set properly, use HypDeleteMetaData() before retrieve step.
Load more