I am trying to count/find the page count. or more like to find how many pages(N's) are within Y(each Y)..
example:
(Col1) (Col2) (what im trying to get in the nxt col)
1 Y 3
2 N
3 N
4 Y 1
5 Y 5
6...
I have a column, with about 669 cells filled with info and 719 empty...total of 1388 cells...im trying to make a new empty row to separate them...separated by the next value...
not sure to use what formula, either =left or =len or what to use.
heres an example
col 1 col 2
BTC Y
BTC
BTC Y
BTC...
heres the table info
in table 'Dlexload' i have
Bates
pah
doc
vol
in 'Bates' table, i have
ID
DOCname
Bates
counter
in order for me to take Bates from Bates table, merge that specific column with Dlexload table, what do i have to in order to do so?? because i tried, i do get it to show in the...
just Bate, theres no other fields that could be linked...is ther way where i could just delete the field in table1, and replace/add it with the field from table2?? to make things easier...
im trying to move/copy a colomn("bates") from table two, and place/replace/insert it in table 1("bates" colomn, same table name but different values)(or, just insert it to table 1, without replacing anything)...i been trying join, inner, left, outer, etc, nothing works, i get it show in table1...
im tired of adding and adding in order to get to a certain number...
example
15000 + 15000 = 30000
30000 + 15000 = 45000
45000 + 15000 = 60000
45000 + 15000 = etc.........all the way to 405,000....
is ther a formula/way that can help me retrieve those numbers, all in one row?
thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.