excel - Match relative values -

-

i earlier posted here did not find answer.

is possible compare column respect specific reference column , if match found re-arrange column respect reference column.

for example have this.

10.0    10.1 10.2    12.4 10.4    13.5 10.6    14.4 10.8     11.0     11.2     11.4     11.6     11.8     12.0     12.2     12.4     12.6     12.8     13.0     13.2     13.4     13.6     13.8     14.0     14.2     14.4

and want convert this.

10.0    10.1 10.2     10.4     10.6     10.8     11.0     11.2     11.4     11.6     11.8     12.0     12.2     12.4    12.4 12.6     12.8     13.0     13.2     13.4    13.5 13.6     13.8     14.0     14.2     14.4    14.4

or this

10.0    10.1    10.1 10.2    12.4     10.4    13.5     10.6    14.4     10.8         11.0         11.2         11.4         11.6         11.8         12.0         12.2         12.4            12.4 12.6         12.8         13.0         13.2         13.4            13.5 13.6         13.8         14.0         14.2         14.4            14.4

which ever feasible. possible or not?

try formula in c2,

=if(aggregate(15, 6, b$2:b$5/(b$2:b$5>=a2), 1)<>aggregate(15, 6, b$2:b$5/(b$2:b$5>=a3), 1), aggregate(15, 6, b$2:b$5/(b$2:b$5>=a2), 1), "")

fill down.

        stagger_if


Comments

Post a Comment

Popular posts from this blog

Google sheets equipment borrowing system -

-
i working on google sheets system shows has item. have never worked google apps script before, want check value of c2, make sheet copy of data (d2, e2, g2) here (it trying copy 2nd column) , move here (in different sheet same document) next corresponding name on each particular section i think want rotate data columns becomes rows, , rows become columns, right? what need [transpose][1] function. for example, in a2, if put =transpose('sheet 2'!c1:1) , google sheets automatically fill column values of first row of 'sheet 2', starting @ c1 position. updated answer: here working example here steps: get filtered list of timestamp matched equipment sort list it's reverse order get first item sorted list ("last date") get position of "last date" in timestamp list get item in action list @ same position "last date" if item "check out" it's not available. note: might want store result of index() ...
Read more

c# - Convert type 'System.Collections.Generic.List<string>' to 'System.Collections.Generic.IList<>' -

-
in model account have property this public list<string> roles { get; set; } later on want property convert ilist<iapplicationuserrole<role>> , have function public ilist<iapplicationuserrole<role>> roles { { return _account.roles; // how convert in specific type intended. } } here iapplicationuserrole public interface iapplicationuserrole<trolemodel> : irole<string> trolemodel : entitymodel { trolemodel role { get; set; } string name { get; set; } } i newbie thing. looking forward help. say have implementing class like: public class applicationuserrole : iapplicationuserrole<t> t : role { public applicationuserrole() { } public user user { get; set; } public t role { get; set; } } then, you'd this: public ilist<iapplicationuserrole<role>> roles { { return _account.roles .select(r => ...
Read more

python - gcc error on install of tesseract-ocr -

-
i trying run following code on mac. import image enter code here`import pytesseract im = image.open('test.png') print pytesseract.image_to_string(im) following question here: pytesseract-no such file or directory error need install tesseract-ocr but when try pip install tesseract-ocr following errors: creating build/temp.macosx-10.5-x86_64-2.7 gcc -fno-strict-aliasing -i//anaconda/include -arch x86_64 -dndebug -g -fwrapv -o3 -wall -wstrict-prototypes -i//anaconda/include/python2.7 -c tesseract_ocr.cpp -o build/temp.macosx-10.5-x86_64-2.7/tesseract_ocr.o tesseract_ocr.cpp:264:10: fatal error: 'leptonica/allheaders.h' file not found #include "leptonica/allheaders.h" ^ 1 error generated. error: command 'gcc' failed exit status 1 i don't know do. you need install libleptonica-dev in system; sudo apt install libleptonica-dev
Read more