- Post deleted #12328767
-
djhurt
on
28 Mar 21 @ 09:03 AM #
mga sir, baka meron kyong magandang inventory system para sa pagtrack ng mga container sa water station. parang pwede isearch yung code ng container then hahanapin nya kung kaninong client's na napahiram. salamat po sa makakatulong
-
dodick
on
28 Mar 21 @ 01:52 PM #
^in excel sheet ba ito? kung meron ka ng format pm msa akin, let's see...
-
pixelspics
on
29 Sep 21 @ 05:17 PM #
Patulong sa excel file. Panu po transfrom yung table sa excel file as below
*********** original table *******************
Column A Column B
A 2
A 3
B 5
C 6
C 7
************** Transform to below ****************************
Column A Column B Column C
A 2 3
B 5
C 6 7
Bale yung mga numbers nasa Column B and Column C. Di lang maayus pagkakaadjust ng tipidpc.
thanks.
-
dodick
on
29 Sep 21 @ 07:42 PM #
@pixelspics
formula is working except that u only need to filter Col A removing "FALSE" to show the correct output.
Steps:
Orig table should be in Sheet1 and output in Sheet2. Copy paste the below formula in Sheet2.
A1:=IF(Sheet1!A1=Sheet1!A2,Sheet1!A1)
B1:=IF(A2=FALSE,Sheet1!B1)
C1:=IF(Sheet1!A1=Sheet1!A2,Sheet1!B2,"")
then select A1 to C1 then copy drag till which row has data on Sheet1.
Filter A1 removing "FALSE" on the List... and wallah! you have the same output. Gud luck!
-
pixelspics
on
05 Oct 21 @ 04:16 PM #
@dodick
thanks po
-
djhurt
on
22 Oct 21 @ 02:53 PM #
boss @ram2010 me msg po ako sainyo. pacheck naman salamat.
-
djhurt
on
22 Oct 21 @ 02:58 PM #
sir dodick me message ako sainyo pwede po pacheck. salamat
-
dodick
on
23 Oct 21 @ 08:54 PM #
ngreply nko sa pm, pro ulitin ko nrn dto. kya sya di nagdidisplay gawa ng format ng cell na minention mo at nkalock din ata. best way is mgcopy ka nlng sa ibang cel then paste mo pra marestore ung normal format at mgdisplay sya. then use formula pra matic na plagi ung Sum Total nya.
-
djhurt
on
03 Nov 21 @ 01:30 PM #
Salamat pre, actually nafigure it out ko nadin na kaya pla di sya nakikita eh nakawhite color yung font. naayos ko nadin, ang issue na lang e yung mejo matagal yung pagupdate pagnirun yung macros.
-- edited by djhurt on Nov 04 2021, 06:36 PM
-
crenson
on
21 Dec 23 @ 01:50 PM #
hello @djhurt
meron akong inventory storage management excel sheet, madali lang syang baguhin, kung gusto mo ng sample message mo lang ako dito sa tipidpc para I share ko sa iyo yong file tru email.
---cheers
crenson