Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-13-2019, 10:50 PM
AndrePrevin AndrePrevin is offline IF statements and columns Windows 10 IF statements and columns Office 2019
Novice
IF statements and columns
 
Join Date: Jan 2019
Posts: 1
AndrePrevin is on a distinguished road
Default IF statements and columns

Hi all, really need your help



I have a series of values and blanks randomly distributed in one column and I want to set up a formula in the next column which looks at the first column and says, if there is a value in first column then take that value, otherwise if there is a blank then use the last cell in which a number occurred.

But where it gets a bit complicated is - I want the formula to update the value which it uses from the first column every time a new number occurs in that column, meaning that as the first column encounters a new value after a series of blanks, the formula will discard the old or previous value and take the new one

To give an idea of what I mean, column B's formula must display the last value from column A even when it encounters blanks in column A until it encounters a new value in column A at which point it must update its output to that new encountered value from column A


Not sure if this is even possible but I will be really grateful if some kind person could help me with this, please

Thank you
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with nested If statements Aliwoods Excel 7 07-16-2018 06:18 AM
IF statements and columns Conditional checkbox mailmerge: coding "or" statements within IF statements mtracy16 Mail Merge 3 05-22-2018 02:03 PM
Combined MAX and IF statements? ddansie Excel 8 07-05-2017 08:49 AM
IF statements and columns Help with if then statements brent chadwick Word VBA 35 07-25-2015 02:41 PM
IF statements and columns Using IF statements stuwoolf Excel 2 01-10-2015 01:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft