Scrip_Tips

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

[Scrip_Tips @Scrip_Tips]

#Excel: If #VLookUp Column is Text then there is no need to format it as #. Prefix LookUp # with "" to get results.

[Scrip_Tips @Scrip_Tips]

Hapi #Pi Day!

Formatting using date functions in XL/BO,

#Excel: TEXT(TODAY(),"m.dd") = 3.14

#BO: FormatDate(CurrentDate(); "M.dd") = 3.14

[Scrip_Tips @Scrip_Tips]

#Excel #Formula: Using the #Count and #Offset Functions, one can display the Nth Instance of a particular #Key in... https://t.co/o8JhUOZr80

[Scrip_Tips @Scrip_Tips]

#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.

[Scrip_Tips @Scrip_Tips]

#Excel #VBA: Another variation to the last row formula. For Col B,

Range("B" & Rows.Count).End(xlUp).Row... https://t.co/3SjFklkaWS

[Scrip_Tips @Scrip_Tips]

#Excel #VBA: Another variation to the last row formula. For Col B,

Range("B" & Rows.Count).End(xlUp).Row

Previous: https://t.co/cieT7FFX5O

[Scrip_Tips @Scrip_Tips]

#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]

#Excel #WEBI: A nice article on combining Spreadsheet and Universe data in SAP BO reporting using merged dimensions.
https://t.co/RIdhgqMZkJ

[Scrip_Tips @Scrip_Tips]

@HionV: Glad it was helpful and let us know if there are any technical topics that we can address in future posts & appreciate the feedback!

[Scrip_Tips @Scrip_Tips]

#Excel #VBA: This one liner can help to quickly convert #s stored as text into #s better than GUI method.

Selection.Value = Selection.Value

[Scrip_Tips @Scrip_Tips]

#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]

#Excel: A comparison of #String joining #Functions especially #TEXTJOIN which offers much more robust features... https://t.co/ko29lbDDml

[Scrip_Tips @Scrip_Tips]

#Excel: A comparison of #String joining #Functions especially #TEXTJOIN which offers much more robust features than #CONCAT or #CONCATENATE.

[Scrip_Tips @Scrip_Tips]

#OneDrive: To access PC Files from any other Laptops, Tablets or Mobile Devices through the MS OneDrive Cloud... https://t.co/fGRf6xzLo2

[Scrip_Tips @Scrip_Tips]

#OneDrive: To access PC Files from any other Laptops, Tablets or Mobile Devices through the MS OneDrive Cloud enable the option shown below.

[Scrip_Tips @Scrip_Tips]

#CMD: When uninstalling #UNIX #Emulator on #Windows, delete #unremovable files using the \\.\ or \\?\ path prefix

Del \\.\C:\Cygwin\CON.cif

[Scrip_Tips @Scrip_Tips]

#Excel: A #Financial % #Allocation method can be used to derive detailed obj (BUD) based on summary ref (ACT) #data.

[Scrip_Tips @Scrip_Tips]

#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]

#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]

#Outlook: Ensure #Privacy on all #Calendar Items when others schedule #Meetings by setting read permissions to None.

[Scrip_Tips @Scrip_Tips]

#Excel #VBA: Do loops are dynamic alternatives to For loops and gives options to check conditions at beginning (While) or ending (Until)