Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #16  
Old 12-26-2018, 10:33 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 942
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

But that's just what you have in the workbook I uploaded in cells K10:K12
Reply With Quote
  #17  
Old 12-27-2018, 12:48 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
 
Join Date: Jul 2018
Posts: 118
ganesang is on a distinguished road
Default

Hi XOR

I am just using this way now.

If J10 or INPUT value is empty will return as empty instead of empty tag.

Is this possible?

thanks
ganesang
Reply With Quote
  #18  
Old 12-27-2018, 01:40 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 942
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

Take a look here.
Attached Files
File Type: xlsx Category_2.xlsx (22.1 KB, 2 views)
Reply With Quote
  #19  
Old 12-27-2018, 01:57 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 349
ArviLaanemets is on a distinguished road
Default

A possible solution.
Attached Files
File Type: xlsx Sample_data.xlsx (11.3 KB, 4 views)
Reply With Quote
  #20  
Old 12-27-2018, 02:01 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 942
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

@ArviLaanemets

Really, considering what OP wrote in #13.
Reply With Quote
  #21  
Old 12-27-2018, 02:14 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 349
ArviLaanemets is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Really, considering what OP wrote in #13.
OK! I omitted this - was only browsing later posts!

It is even possible to do without hidden columns - using dynamic names instead. But having up to 100 dynamic names defined, I'm not sure what will happen with workbook speed!
Reply With Quote
  #22  
Old 12-27-2018, 03:26 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
 
Join Date: Jul 2018
Posts: 118
ganesang is on a distinguished road
Default

Awesome Guys!!!

Almost i reached my goal

Thanks much!!!!
Reply With Quote
  #23  
Old 12-27-2018, 03:53 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
 
Join Date: Jul 2018
Posts: 118
ganesang is on a distinguished road
Default

Hi XOR

One more help

if INPUT cell contain the function or formula its not considered as blank or empty cell and added empty tag also.


Please advise.
Reply With Quote
  #24  
Old 12-27-2018, 04:08 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 942
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

Can't you explain better?
I'm not sure what you mean.
Reply With Quote
  #25  
Old 12-27-2018, 04:12 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
 
Join Date: Jul 2018
Posts: 118
ganesang is on a distinguished road
Default

I have added the function to get INPUT value in cell J5 from another Sheet 1.

If there is no value in the Sheet 1 in particular cell, then returns J5 as empty.

So, in this case your function is put the empty code like <caget no = ""/>.

When trying to delete the function from J5 the empty tag is disappeared.

Is there any other way to retain the formula? in cell J5 without put empty code
Reply With Quote
  #26  
Old 12-27-2018, 04:14 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 942
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

Please upload your workbook.
Reply With Quote
  #27  
Old 12-27-2018, 04:29 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
 
Join Date: Jul 2018
Posts: 118
ganesang is on a distinguished road
Default

I need the yellow highlighted items in sheet 2 as empty without adding empty tags.
Attached Files
File Type: xlsx Book1.xlsx (15.4 KB, 3 views)
Reply With Quote
  #28  
Old 12-27-2018, 04:45 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 942
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

See the attached.
Attached Files
File Type: xlsx Category_3.xlsx (15.4 KB, 3 views)
Reply With Quote
  #29  
Old 12-27-2018, 05:17 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 349
ArviLaanemets is on a distinguished road
Default

Or this!

To add reference levels, you have to add names strng#, text# and txtl# with according level number, and add according components to concantenate in name strng.

With this approach, there will be no need for helper columns, but you have to check it out yourself with large number of levels and source rows.

Btw, I checked it out with formula "=IF(1=1,"","") in column A of Sheet1 - the name strng returns empty string when formula in source cell returns empty string.

Update! When adding/editing dynamic names strng#, text# and txtl#, you MUST have some cell (on any sheet) - with same row number as the one you put into name formula - to be active! Otherwise references will be wrong (to wrong row)!
Attached Files
File Type: xlsx Sample_data2.xlsx (11.7 KB, 2 views)
Reply With Quote
  #30  
Old 12-27-2018, 05:31 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
 
Join Date: Jul 2018
Posts: 118
ganesang is on a distinguished road
Default

Thanks both of you!!!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help need for concatenate function issue ganesang Excel 5 11-24-2018 12:27 AM
RIGHT Function With Concatenate (?) VBA-Need Help with Macro rsrasc Excel Programming 4 08-22-2018 12:17 PM
Concatenate b16 Excel 1 01-09-2017 04:51 PM
Concatenate function for displaying numbers in words officeboy09 Excel 12 10-30-2013 08:08 PM
If, move and concatenate in VBA devcon Excel Programming 0 07-04-2011 12:44 AM


All times are GMT -7. The time now is 06:36 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft