Friday, March 4, 2016

Troubleshooting:How to concatenate this, please help Error

How to concatenate this, please help

Hi

Look at my data


R
2841,2842,2843,2844,2845,2846,2847,2848,

 
2881,2882,2894

R
2841,2842,2843,2844,2845,2846,2847,2848,

 
2881,2882,2894

R
2841,2842,2843,2844,2845,2846,2847,2848,

 
2881,2882,2894

R
2841,2842,2843,2844,2845,2846,2847,2848,

 
2881,2882,2894

R
2841,2842,2843,2844,2845,2846,2847,2848,

 
2881,2882,2894

R
2841,2842,2843,2844,2845,2846,2847,2848,

 
2881,2882,2894

R
2841,2842,2843,2844,2845,2846,2847,2848,

 
2881,2882,2894

R
2841,2842,2843,2844,2845,2846,2847,2848,

 
2881,2882,2894


The first column here is G in my worksheet, and the numbers are in F column.
Note that the G column contain one letter "R" and its every second row is blank..
With a formula how can I combine the 2nd row numbers with the first.
For example 2841,2842,2843,2844,2845,2846,2847,2848, 2881,2882,2894

Anwsers to the Problem How to concatenate this, please help

Download SmartPCFixer for Free Now

Hi Haque,
Your formula is very nearly there...
try instead:
=IF(OR(E2="R","I","M"),F2&F3,"")
 
________________
Regards, Tom

Use the System File Checker tool to repair corrupted or missing system files:

  1. Click Start.
  2. Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
  3. The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
  4. Type or copy paste the below command line into it without quotes:
  5. "Sfc /scannow"

Recommended Method to Fix the Problem: How to concatenate this, please help:

 

 

How to Fix How to concatenate this, please help with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your computer. When you open SmartPCFixer, it will perform a scan.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.


Related: 1 exe exeCmd exe 0Xc0000142 Sysinfo exe Error Exe Is Not A Valid Win32 Application Dgl Exe Bad Image Exp exe Autoupdate exe Application Error hpqwmiex exe windows6 1 kb976932 x86 exe isass exe what is dwm exe Lbtserv Exe IEXPLORE EXE App Crash nsd exe wdfmgr exe virus sleep exe Szmsgsvc exetabuserw exe Telecharger Reg33 exe cisvc exe Wwdisp exe Cleanup Exe Free Downloads,Can a WIndows Easy Tranfer File from Windows 8 be opened in Windows 7 sony drivers How do I transfer my address book from Outook Express on my old computer which runs on XP to my new laptop running Windows 7 vaio drivers I have Windows7 Professional with 64 bit operating system with room for 6 memory modules how high can i go vaio drivers Shutdown and Logon Issue Windows 7 vaio drivers SSMMgr exe has stopped working a problem caused the program to stop working correctly Windows will close this program and notify you if a solution is available 2 days Error Could not find the macromedia flash VAIO Driver Download Windows 7 fresh install from XP randomly becomes unresponsive and then recovers after 10 100 seconds sony drivers Windows Vista issue on installing Skype Toolbars vaio drivers Ways to Recognize an ASUS Motherboard
Read More: How to Resolve - device error 0x8007045d?,Cannot connect IPAD to internet,i need formula to show only last four digits of bank account number,Open Wireless Networks At Home,Dell XPS 8300 is unable to connect to my router. I am told that it fails to connect.,Everytime Windows Updates, My Explorer Will Not Work,I can not get IE to work. I get an error 403(forbidden) What can I do?,my laptop won't start. it says "windows failed to start. a recent hardware or software change might be the cause." i've tried launch startup repair and it doesn't work.

No comments:

Post a Comment